Quote from: menion on September 23, 2013, 21:47:21
I'm worried that more then magic, this autoloading is buggy and will definitely needs some more attention from my side soon. Anyway on JB, should be for sure limit 4GB. Looks it's even more, perfect
menion, on larger DBs like MSSQL we have the "check" key, which basically provides the limits on data in a table. this way, sql knows the range of data in a table and ignores scans if the data is outside of the range.
You could add another column table in the sqldb file that provides the ranges of the x,y tiles, so you can avoid a scan. (maybe you are already storing this, I don't know).
Or, use the filenames to provide hints eg: <map name>_z_x_y_<x limit>_<y limit>
the maps work fine, only thing i noticed is that tile loading bug. when the zoom is not 100%, Locus fails to load tiles. I do not have shading turned on.