t...@qvgps.com wrote: > The larger the db, the slower is the fetching! > > My assumption is, that in the big db, these 1000 lines are just spread over a > much higher count of pages. > So more page-loads resulting in more time.
Correct. > We changed page_size to the maximum value of 64k and it became much better, > but still I would lke to improve it. Store the table entries so that nearby objects are stored nearby. One way to do that would be to insert the ways ordered first by Z, then by the position on a space-filling curve (e.g., Morton order <https://en.wikipedia.org/wiki/Z-order_(curve)>). Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
