The data used for sqlite_stat1 in create.txt is taken from the real data, it's copied from the sql-dump generated just after running ANALYZE.
I only wanted to include the minimum amount of data the demonstrate the issue so I omitted all other tables, views and data. As I understand it sqlite only checks the statN table data when planning the queries and not the actual data in the real tables. I have dropped the sqlite_stat1 table for now and so disabled analyze functionality. This way I avoid the slow queries. Running ANALYZE on the database again will immediately make them return though. -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
