Re: Very long "WHERE" list.

On Sat, 10 Jul 2004 19:37:04 +1000, Noons <wizofoz2k_at_yahoo.com.au.nospam> wrote:

>Mikito Harakiri apparently said,on my timestamp of 10/07/2004 5:40 AM:
>
>> wizofoz2k_at_yahoo.com.au (Noons) wrote in message news:<73e20c6c.0407082252.14e6fd5c_at_posting.google.com>...
>>
>>>>Unfortunately Oracle can not process this request directly.
>>>
>>>Correction: NO DATABASE whatsoever can process that query,
>>>not just Oracle.
>>
>> You have to make a little research before dumping blant statements.
>> What fundamental limitation on the implementation side would make
>> processing such query impossible?
>
>You have to make a little bit more research before dumping refutations
>like that: which database can cope with 20000 elements in an in-list?

 A quick test shows that MySQL 4.0.18 can.

#!/usr/bin/perl
my $monstroInlist = join ',', (1..20000); print <<END_SQL;
select count(*)
from t
where id in ($monstroInlist);
END_SQL  Output dumped to monstroInlist.sql, and run against the database:

mysql> \. monstroInlist.sql
+----------+
| count(*) |
+----------+
| 20000 |
+----------+
1 row in set (2.39 sec)

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