Re: [sqlite] Performance regression between 3.7.17 and 3.8.0.2?

2014-09-21 Thread RSmith
On 2014/09/21 15:39, Merike wrote: Now I could very well be wrong about that as you say in your other reply that "It might simply be that Analyze did not get your QP to react on that size DB as it did for us". You seem to be saying that analyze behaves differently depending on database size...

Re: [sqlite] Performance regression between 3.7.17 and 3.8.0.2?

2014-09-21 Thread Merike
21.09.2014 00:08, Richard Hipp kirjutas: > On Sat, Sep 20, 2014 at 12:45 PM, Merike wrote: > >> 19.09.2014 04:21, Richard Hipp kirjutas: >>> A simple script to reproduce the problem in the latest SQLite is as >>> follows: CREATE TABLE t1(a INTEGER PRIMARY KEY, b INTEGER, c

Re: [sqlite] Performance regression between 3.7.17 and 3.8.0.2?

2014-09-21 Thread Merike
21.09.2014 15:12, RSmith kirjutas: > Merike: Running Analyze did not fix the bug, it simply changed some > internal-use values that allowed the bug to be circumvented. If you > re-make a table as you had without running analyze, the problem will > surely remain using the same codebase. Updating

Re: [sqlite] Performance regression between 3.7.17 and 3.8.0.2?

2014-09-21 Thread RSmith
On 2014/09/21 14:12, RSmith wrote: On 2014/09/20 23:08, Richard Hipp wrote: On Sat, Sep 20, 2014 at 12:45 PM, Merike wrote: A question: is the query being fast again after analyze call indicative of the bug being fixed? Because I tried it on my original database too and

Re: [sqlite] Performance regression between 3.7.17 and 3.8.0.2?

2014-09-21 Thread RSmith
On 2014/09/20 23:08, Richard Hipp wrote: On Sat, Sep 20, 2014 at 12:45 PM, Merike wrote: A question: is the query being fast again after analyze call indicative of the bug being fixed? Because I tried it on my original database too and there I don't see a speedup after

Re: [sqlite] Performance regression between 3.7.17 and 3.8.0.2?

2014-09-20 Thread Richard Hipp
On Sat, Sep 20, 2014 at 12:45 PM, Merike wrote: > 19.09.2014 04:21, Richard Hipp kirjutas: > > A simple script to reproduce the problem in the latest SQLite is as > > follows: CREATE TABLE t1(a INTEGER PRIMARY KEY, b INTEGER, c INTEGER, > > d INTEGER); CREATE INDEX t1b ON t1(b);

Re: [sqlite] Performance regression between 3.7.17 and 3.8.0.2?

2014-09-20 Thread Merike
19.09.2014 04:21, Richard Hipp kirjutas: > A simple script to reproduce the problem in the latest SQLite is as > follows: CREATE TABLE t1(a INTEGER PRIMARY KEY, b INTEGER, c INTEGER, > d INTEGER); CREATE INDEX t1b ON t1(b); CREATE TABLE t2(x INTEGER > PRIMARY KEY, y); explain query plan SELECT *

Re: [sqlite] Performance regression between 3.7.17 and 3.8.0.2?

2014-09-19 Thread Merike
19.09.2014 05:24, Richard Hipp kirjutas: > Thanks again for the regression report. This problem is now fixed on > the SQLite trunk. See > http://www.sqlite.org/src/info/72727b68cd0796?dc=22 for the check-in > that fixes the problem. > > If all you want to know is that the problem has been fixed,

Re: [sqlite] Performance regression between 3.7.17 and 3.8.0.2?

2014-09-18 Thread Richard Hipp
On Thu, Sep 18, 2014 at 8:54 AM, Merike wrote: > Hi everyone, > > Since upgrading to Kubuntu 14.04 I've had an issue with Quassel irc > client being slow on startup when it retrieves backlog from database. > I've tracked it down to different sqlite version being installed. >

Re: [sqlite] Performance regression between 3.7.17 and 3.8.0.2?

2014-09-18 Thread Richard Hipp
On Thu, Sep 18, 2014 at 8:54 AM, Merike wrote: > Hi everyone, > > Since upgrading to Kubuntu 14.04 I've had an issue with Quassel irc > client being slow on startup when it retrieves backlog from database. > I've tracked it down to different sqlite version being installed. >