List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:March 15 2010 3:53pm
Subject:Re: Very slow subselect (parser bug)?
View as plain text  
On Mon, Mar 15, 2010 at 4:22 PM, Pascal Gienger <
Pascal.Gienger@stripped> wrote:

> Using this result to reconstruct the first left outer join from the initial
> statement, I get this result:
>

Not so much a bug as a missing feature: the parser is currently unable to
recognize any subselect as being fully independent, and will thus execute it
for each and every row in your primary select.

You may or may not get better results by rewriting it so the subselect is a
virtual table. If that doesn't help, subselect into temptable and use that,
or do the reconstruction in code, or other dirty tricks. YMMV.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
Very slow subselect (parser bug)?Pascal Gienger15 Mar
  • Re: Very slow subselect (parser bug)?Johan De Meersman15 Mar