Hi, we encountered an issue where a query that performed well using SQLite 3.8.4.1 (i.e. execution time way below 1 second) suddenly took several seconds to execute. Unfortunately, I could not yet reduce the query and database to a sample that I could send along and the real query / database is not something I can disclose to the public.
Also, I saw the query performance differ a lot between two databases (containing similar amounts of records in the involved tables), so it might be related to the correlation between the data populating the tables being used... I can send you the query and information on the tables involved off list as well as "explain query", "explain query plan", etc. results - just let me know what you'd need (although I probably cannot send the actual database involved). I also tried with the July 14th SQLite 3.8.11 draft (sqlite-amalgamation-201507141718.zip) - but I have not yet tried with the 3.8.11 release sources - and the performance of 3.8.11 was similar to 3.8.8 for that query. Running "ANALYZE" and "vacuum" also did not improve the performance for those DBs that took the performance hit. Sorry for the fuzzy "bug report", I really would have liked to provide you with a reproducible snippet, but so far I have been unable to pin down what makes things go slow on certain DBs... Let me know how I can help figuring out what's going on. Thanks, -jens