Re: Very long "WHERE" list.

Noons <wizofoz2k_at_yahoo.com.au.nospam> wrote:
> Jonathan Lewis apparently said,on my timestamp of 11/07/2004 11:40 PM:
>
> > Notes in-line.
> >
> >
>
> So let me see: you agree that putting 20000 values in
> an IN list is an efficient way of performing a
> lookup on those values?

If there is not a way to obtain those 20,000 values by any compact query from within the database, I think that that is a very efficient way of performing a look-up on those values.

Xho

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