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...
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 INTEGER,
>>> d INTEGER);
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 you
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 there I don't see a
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 analyze. Should I try t
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); CREATE TABLE t2(x
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 * FR
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,
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.
> Previously I had 3.7.
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.
> Previously I had 3.7.
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.
Previously I had 3.7.17 and now have 3.8.2. I've tried various versions
from http
11 matches
Mail list logo