Re: [sqlite] Severe performance degradation between 3.8.4.3 and

On Fri, 22 Aug 2014 19:14:02 +0200 "Mario M. Westphal" wrote: > Thanks, Richard > > > > After swapping back to the latest SQLite version and running an > Analyze on the sample databases, performance is up to the same level > as before (maybe even a bit faster). Very good. >

Re: [sqlite] Severe performance degradation between 3.8.4.3 and

Thanks, Richard After swapping back to the latest SQLite version and running an Analyze on the sample databases, performance is up to the same level as before (maybe even a bit faster). Very good. I will send out a recommendation to my users to run the weekly diagnostics routine

Re: [sqlite] Severe performance degradation between 3.8.4.3 and

On Thu, Aug 21, 2014 at 2:15 PM, Mario M. Westphal wrote: > > When I understand you correctly, I should/must run an ANALYSIS on existing > databases > SQLite will get the correct answer regardless. But you might get the answer *faster* if you run ANALYZE after significant

Re: [sqlite] Severe performance degradation between 3.8.4.3 and

The sample database was produced by a version of my software which runs the previous (or even an older version of SQLite). My software runs an Analysis as part of a weekly database maintenance procedure. But the users can turn this off or delay it for weeks. Various versions of my software

Re: [sqlite] Severe performance degradation between 3.8.4.3 and

On Thu, Aug 21, 2014 at 7:35 AM, Mario M. Westphal wrote: > Hi, Richard > > I have prepared a sample database, sample statements and some additional > details and sent it to your email address. > Thanks for sending the sample data. Here is what I found: Your ANALYZE

Re: [sqlite] Severe performance degradation between 3.8.4.3 and

On Thu, Aug 21, 2014 at 7:35 AM, Mario M. Westphal wrote: > Hi, Richard > > I have prepared a sample database, sample statements and some additional > details and sent it to your email address. > Thanks for the info. I'll look into the performance regression as soon as I get a

Re: [sqlite] Severe performance degradation between 3.8.4.3 and

Hi, Richard I have prepared a sample database, sample statements and some additional details and sent it to your email address. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Severe performance degradation between 3.8.4.3 and

On Thu, Aug 21, 2014 at 5:18 AM, Richard Hipp wrote: > > > > On Thu, Aug 21, 2014 at 3:21 AM, Mario M. Westphal wrote: > >> Hi, >> >> >> >> Information provided as requested. >> > > But not in a form that we can use. > > Please bring up your database file in a

Re: [sqlite] Severe performance degradation between 3.8.4.3 and

Mario M. Westphal wrote: > _temptable is a temporary table which contains a list of oids (integer, ~ 10 > rows) to consider. The information that oid is INTEGER PRIMARY KEY would have been helpful ... > For query 2.1 > > selectid order from detail > 1 0 0

Re: [sqlite] Severe performance degradation between 3.8.4.3 and

On Thu, Aug 21, 2014 at 3:21 AM, Mario M. Westphal wrote: > Hi, > > > > Information provided as requested. > But not in a form that we can use. Please bring up your database file in a new 3.8.6 sqlite3.exe shell and type ".fullschema" and then post the output. You might want

Re: [sqlite] Severe performance degradation between 3.8.4.3 and

Hi, Information provided as requested. _temptable is a temporary table which contains a list of oids (integer, ~ 10 rows) to consider. Stats3 tbl idx neqnlt ndltsample stack_elem idx_rel_stack_elem_soid 4

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

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

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.