Re: Very long "WHERE" list.

Noons <wizofoz2k_at_yahoo.com.au.nospam> wrote:
> Andy Hassall apparently said,on my timestamp of 11/07/2004 11:08 PM:
>
> >
> > mysql> \. monstroInlist.sql
> > +----------+
> > | count(*) |
> > +----------+
> > | 10001 |
> > +----------+
> > 1 row in set (2.38 sec)
>
> Interesting. Must be doing some lookup optimisation to get
> this time.

Why must it? On my machine, that is over 250,000 clock ticks per row. That should be more than enough time to do a co-local lookup into a index and lookup into a table with a good cluster factor on the indexed column.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB