Re: [sqlite] Severe performance degradation between 3.8.4.3 and 3.8.6

2014-08-21 Thread Clemens Ladisch
Mario M. Westphal wrote: > The new version is 10 or more times slower than the previous build I used > (3.8.4.3). > [...] > If more information or sample data is needed, let me know. What is _temptable? If you have run ANALZYE, what are the contents of the sqlite_stat* tables? What is the

[sqlite] Severe performance degradation between 3.8.4.3 and 3.8.6

2014-08-20 Thread Mario M. Westphal
Hello, After re-compiling my Windows application (compiled with Visual C++ 2012, 32 Bit application) with the latest SQLite version (3.8.6) I noticed a severely degraded performance with certain queries. The new version is 10 or more times slower than the previous build I used (3.8.4.3). 1.