> Can you give me some row of your db (also fake data are ok) so I try to > populate a db with 840k row and test your query on my machine ... > You can either take these rows here:
Pietraporzio|5|-1|7.032936|44.345913 Sambuco|5|-1|7.081367|44.33763 Le Pra|6|-1|6.883333|44.316667 Bagni|6|-1|7.083333|44.3 Argentera|6|-1|6.937569|44.396168 Bersezio|6|-1|6.970739|44.377898 Saint-Dalmas-le-Selvage|6|-1|6.867705|44.285194 Ferrere|6|-1|6.950052|44.354508 San Bernolfo|6|-1|7.039278|44.263371 Murenz|6|-1|6.998868|44.348969 Bagni di Vinadio|6|-1|7.074884|44.290033 or you can download a 170 MB big database similar to the one i am using, but populatet with free data from geonames.org from http://www.multimedial.de/earth/DB/free.7z That one is 1.4 Gb unpacked, and has yet no indices (i think, i prepared it some time ago). It should yield to similar results. Thanks for your time, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users