Re: [sqlite] Performance regression since 3.7.15

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

Re: [sqlite] Performance regression since 3.7.15

> 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

Re: [sqlite] Performance regression since 3.7.15

>> 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

[sqlite] Performance regression since 3.7.15

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