Re: [sqlite] [BUG] 1200x slow-down running query in 3.7.3

2010-10-21 Thread Richard Hipp
On Mon, Oct 18, 2010 at 9:18 AM, Peter wrote: > I have a query which takes 17 minutes to run with 3.7.3 against 800ms > with 3.7.2 > > explain query plan with 3.7.3: > 0 0 TABLE sheep AS s > 1 1 TABLE flock_owner AS prev WITH INDEX >

Re: [sqlite] [BUG] 1200x slow-down running query in 3.7.3

2010-10-20 Thread Donald Griggs
On Mon, Oct 18, 2010 at 9:18 AM, Peter wrote: > I have a query which takes 17 minutes to run with 3.7.3 against 800ms > with 3.7.2 > > The query is: > > SELECT x.sheep_no, x.registering_flock, x.date_of_registration > FROM sheep x LEFT JOIN > Regarding: "Turning

Re: [sqlite] [BUG] 1200x slow-down running query in 3.7.3

2010-10-20 Thread Peter
>> On Mon, Oct 18, 2010 at 9:18 AM, Peter wrote: >> > I have a query which takes 17 minutes to run with 3.7.3 against 800ms >> > with 3.7.2 >> > >> > > Thank you for the report. > > Can you please send your complete schema. The query is useful in > combination

Re: [sqlite] [BUG] 1200x slow-down running query in 3.7.3

2010-10-19 Thread Richard Hipp
On Mon, Oct 18, 2010 at 9:18 AM, Peter wrote: > I have a query which takes 17 minutes to run with 3.7.3 against 800ms > with 3.7.2 > > Thank you for the report. Can you please send your complete schema. The query is useful in combination with the schema but is

[sqlite] [BUG] 1200x slow-down running query in 3.7.3

2010-10-18 Thread Peter
I have a query which takes 17 minutes to run with 3.7.3 against 800ms with 3.7.2 The query is: SELECT x.sheep_no, x.registering_flock, x.date_of_registration FROM sheep x LEFT JOIN (SELECT s.sheep_no, prev.flock_no, prev.owner_person_id, s.date_of_registration, prev.owner_change_date