Re: Highly obscure and erratic

> > hi,
> > I cannot get what causes the difference in the execution of these 2 commands
> > 1. SELECT * FROM dbmedia WHERE ID IN ((SELECT id FROM wdmedia WHERE word = 'whatever') ) LIMIT 20;
> > 2. SELECT * FROM dbmedia WHERE ID IN (1234,2345,1242,1256,1245,1567,2222,22,345,234,567,456,35,56) ;
>
> The former is not very well optimized (see the FAQ for suggestions on
> using EXISTS instead).
hi ,
Had a look at that..
but still it is toooo slow :(
when is it intended to be fixed up??
<excerpt below>
Currently we join subqueries by sequentlialy scanning the result of the
subquery for each row of the outer query.A workaround is to replace IN
with EXISTS
<snip>
We hope to fix this in future release.
<end excerpt>

guys i am waiting for that release ;-).

--
------
Varun
Once I finally figured out all of life's answers.....they changed the questions.