On Fri, Jul 12, 2013 at 3:58 AM, Elan Feingold wrote:
> Just to update, we're attempting to move to a 3.8.0 snapshot, and we've
> run into another possibly pathological case you might want to be aware of
> (same schema).
>
Please try again with the latest snapshot:
http://www.sqlite.org/draft/do
On Fri, Jul 12, 2013 at 3:58 AM, Elan Feingold wrote:
> Just to update, we're attempting to move to a 3.8.0 snapshot, and we've
> run into another possibly pathological case you might want to be aware of
> (same schema). The query is...
>
Thanks for the follow-up report. The following is a simp
Just to update, we're attempting to move to a 3.8.0 snapshot, and we've run
into another possibly pathological case you might want to be aware of (same
schema). The query is:
select count(*) from metadata_items as leaves join metadata_items as parents on
leaves.parent_id=parents.id left join me
He said using the NGQP snapshot the query indeed runs fast. I think you
mentally inserted some negation in that statement, DRH.
On Fri, Jun 28, 2013 at 8:47 AM, Richard Hipp wrote:
> On Thu, Jun 27, 2013 at 6:50 PM, Elan Feingold wrote:
>
> > >> Q2 runs excruciatingly slowly in 3.7.15.2 (1m 28
On Thu, Jun 27, 2013 at 6:50 PM, Elan Feingold wrote:
> >> Q2 runs excruciatingly slowly in 3.7.15.2 (1m 28sec). We then observed
> >> that Q2 was fast in 3.7.14 (300ms), but slow in 3.7.15.2 and later
> (tested
> >> up until 3.7.17).
> >>
> >
> > Have you tried it with the NGQP snapshot?
> >
> >
On Fri, Jun 28, 2013 at 6:32 AM, Eduardo wrote:
> On Wed, 26 Jun 2013 14:23:50 -1000
> Elan Feingold wrote:
>
> > The crux of the query which makes it pathologically slow in 3.7.15+
> appears to be this bit: "join metadata_item_settings on
> metadata_item_settings.guid=grandchild.guid and
>
On Wed, 26 Jun 2013 14:23:50 -1000
Elan Feingold wrote:
> The crux of the query which makes it pathologically slow in 3.7.15+ appears
> to be this bit: "join metadata_item_settings on
> metadata_item_settings.guid=grandchild.guid and
> metadata_item_settings.account_id=1". If I take ou
> Have you run ANALYZE on your database? Does that make a difference?
Yes, and no, it doesn’t seem to make a difference for this query.
> Can you send (1) the schema (2) the query that is giving problems, and (3)
> the content of the sqlite_stat1 table after you have run ANALYZE? If you
> can
On Thu, Jun 27, 2013 at 6:50 PM, Elan Feingold wrote:
> >> Q2 runs excruciatingly slowly in 3.7.15.2 (1m 28sec). We then observed
> >> that Q2 was fast in 3.7.14 (300ms), but slow in 3.7.15.2 and later
> (tested
> >> up until 3.7.17).
> >>
> >
> > Have you tried it with the NGQP snapshot?
> >
> >
>> Q2 runs excruciatingly slowly in 3.7.15.2 (1m 28sec). We then observed
>> that Q2 was fast in 3.7.14 (300ms), but slow in 3.7.15.2 and later (tested
>> up until 3.7.17).
>>
>
> Have you tried it with the NGQP snapshot?
>
> The NGQP was announced on this mailing list yesterday, but I see that
On Wed, Jun 26, 2013 at 8:23 PM, Elan Feingold wrote:
> Hi,
>
> We've observed a severe performance regression in a query.
>
> We had a query Q1, which was running fast, on 3.7.15.2. We made a minor
> change to the query, which we'll call Q2.
>
> Q2 runs excruciatingly slowly in 3.7.15.2 (1m 28se
Hi,
We've observed a severe performance regression in a query.
We had a query Q1, which was running fast, on 3.7.15.2. We made a minor change
to the query, which we'll call Q2.
Q2 runs excruciatingly slowly in 3.7.15.2 (1m 28sec). We then observed that Q2
was fast in 3.7.14 (300ms), but slow
12 matches
Mail list logo