Re: Very long "WHERE" list.

From: Mikito Harakiri <mikharakiri_nospaum_at_yahoo.com>
Date: 10 Jul 2004 11:07:14 -0700
Message-ID: <8a529bb.0407101007.4034f6b8@posting.google.com>

Noons <wizofoz2k_at_yahoo.com.au.nospam> wrote in message news:<40efb8b7$0$16105$afc38c87_at_news.optusnet.com.au>...
> 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?

And the winner is:........ Drumroll................
...........................................
.............................................

..................


...................
...........................................
.............................................

..................


...................

...........................................
.............................................

..................


...................

...........................................
.............................................

..................


...................

My SQL!

According to their doc the number of values in the IN list is only limited by the max_allowed_packet value.

As of MySQL 4.0.2, program variables are set the same way as any other long option that takes a value. For example, mysql has a max_allowed_packet variable that controls the maximum size of its communication buffer. To set the max_allowed_packet variable for mysql to a value of 16MB, use either of the following commands:

shell> mysql --max_allowed_packet=16777216 shell> mysql --max_allowed_packet=16M

P.S. I'm actually kidding, MySQL is the only database I cared to check. Received on Sat Jul 10 2004 - 13:07:14 CDT