On 7 Jun 2013, at 5:37pm, Brad House <b...@monetra.com> wrote: > I've modified my code to run an Analyze on startup to work around this, > but it obviously takes time to run and slows down startup.
I can't answer your question about why this happens in the first place, but I can tell you that the results of ANALYZE are saved in the database file through closing and reopening. If you have run ANALYZE once on data which looks like the data that will be in your database in normal use, then you don't have to run it again. SQLite will continue to use that information about table sizes and 'chunkiness' when devising query plans in the future. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users