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


Reply via email to