On Mon, Jul 25, 2011 at 5:45 PM, Григорий Григоренко <grigore...@mail.ru> wrote: > > 1) SQLITE has to read about _half of index_ before it can use it (and > understand there are no records matching query). > > If cache is enough to hold 50 Mb then on subsuquent queries sqlite process is > not reading at all. >
Please, post your query. To understand whether sqlite reads too much or not it's better to know what exactly you want to select. > 2) SQLITE is reading abnormally slowly during this first-time running query > (waiting for something a lot?). > Is this with the recreated index or still the one that was created during the lifetime of your program? Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users