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
>
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
>> 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
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
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
5 matches
Mail list logo