On 18 Aug 2011, at 2:03pm, Kristoffer Danielsson wrote:
> Hi, The problem is that the database is around 100 MB large (the error goes
> away if I remove unimportant data). Also, it contains data I'd like to keep
> private. I do have a specific select query that produces what I believe is a
>
On Thu, Aug 18, 2011 at 9:03 AM, Kristoffer Danielsson <
kristoffer.daniels...@live.se> wrote:
>
> Hi, The problem is that the database is around 100 MB large (the error goes
> away if I remove unimportant data). Also, it contains data I'd like to keep
> private. I do have a specific select query
qlite.org
> Subject: Re: [sqlite] ANALYZE necessary after database upgrade?
>
> On Thu, Aug 18, 2011 at 8:50 AM, Kristoffer Danielsson <
> kristoffer.daniels...@live.se> wrote:
>
> >
> >
> >
> >
> > I have noticed that certain (complex) select quer
the database and
send it to the sqlite team for analysis? > From: slav...@bigfraud.org
> Date: Thu, 18 Aug 2011 13:57:31 +0100
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] ANALYZE necessary after database upgrade?
>
>
> On 18 Aug 2011, at 1:50pm, Kristoffer Danielsson
On Thu, Aug 18, 2011 at 8:50 AM, Kristoffer Danielsson <
kristoffer.daniels...@live.se> wrote:
>
>
>
>
> I have noticed that certain (complex) select queries return unexpected data
> (missing rows) on my upgraded SQLite databases.My guess is that the
> optimizer makes an erroneous decision on
On 18 Aug 2011, at 1:50pm, Kristoffer Danielsson wrote:
> I have noticed that certain (complex) select queries return unexpected data
> (missing rows) on my upgraded SQLite databases.
What do you mean by 'upgraded' ?
> My guess is that the optimizer makes an erroneous decision on some index
I have noticed that certain (complex) select queries return unexpected data
(missing rows) on my upgraded SQLite databases.My guess is that the optimizer
makes an erroneous decision on some index (I'm using both sqlite_stat1 and
sqlite_stat2). Is this a reasonable guess? Is it necessary to
7 matches
Mail list logo