Hallo list, I detected a dramatic performance drop with a certain query which occurred somewhere between versions 3.7.09.0 and 3.7.17.0. Now this is not a real showstopper because I also noticed than an ANALYZE cures the issue in the latter version immediately. However, the drop without ANALYZE is really dramatic (~5 secs. in 3.7.09.0, but no result even after a couple of hours in 3.7.17.0).
Is this of any interest? If so, I can make a showcase which demonstrates the problem (with obfuscated data). EXPLAIN QUERY PLAN shows essential differences also between the two versions, although every SEARCH TABLE operation uses an index in both cases. While we're at it: is there a place where I can download "historic" precompiled binaries? If so, I could probably tell more exactly where the drop was introduced. Wolfgang _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
