Re: [sqlite] Very important performance regression due to totally different query plan

2013-05-09 Thread Stephane MANKOWSKI
Hi Richard, I found this thread (http://www.mail-archive.com/sqlite-users@sqlite.org/msg76831.html) and applied the same correction. Now, I have good performances on all version of sqlite. Thank you for your help. Regards, Stephane Le 08/05/2013 12:14, Stephane MANKOWSKI a écrit : Hi Richar

Re: [sqlite] Very important performance regression due to totally different query plan

2013-05-08 Thread Stephane MANKOWSKI
Hi Richard, Yes, I already considered including source code but this is not so easy because I develop in fact with QT and the sqlite driver. Anyway, the main reason of my initial post is to: 1-inform you about this important performance regression 2-know if this is normal or if I have to open a

Re: [sqlite] Very important performance regression due to totally different query plan

2013-05-07 Thread Richard Hipp
On Mon, May 6, 2013 at 3:15 PM, Stephane MANKOWSKI wrote: > Hi, > > I am the main developer of Skrooge (application using sqlite) and since my > upgrade to ubuntu 13.04, I have very bad performances due to sqlite. > Have you considered including source code (the sqlite3.c and sqlite3.h files) for

[sqlite] Very important performance regression due to totally different query plan

2013-05-07 Thread Stephane MANKOWSKI
Hi, I am the main developer of Skrooge (application using sqlite) and since my upgrade to ubuntu 13.04, I have very bad performances due to sqlite. Here is my analysis: All tests are done with the file http://skrooge.org/files/skrooge_bug_performance.sqlite *