Re: Very long "WHERE" list.

On Mon, 12 Jul 2004 00:21:44 +1000, 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.

 You should probably ignore the timings, they'll be excessively large; this was on my ancient 200MHz linux machine, run whilst it was downloading and spam filtering (which thrashes the machine a bit) a couple of days worth of email.

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space