can you post those rows with .mode insert so I can do a fast try ? Tnx. -- [image: Just A Little Bit Of Geekness]<http://feeds.feedburner.com/%7Er/JustALittleBitOfGeekness/%7E6/1> Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza. (Larry Wall).
2008/6/4 Christophe Leske <[EMAIL PROTECTED]>: > > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users