Re: IN list processing performance (yet again)

A join isn't an option, these elements come a a selection of entity ID's 
that are specific to some client context.
Some other people suggested joins too. 

Consider it something like this, say there's a database that represents 
the entire file system content
of a set of machines, hundreds of thousands of files.  A single user 
wants to do something
related to the ID's of 3000 files.  The requests for those 3000 files 
can be built up in a number of ways,
not all of which rely on data in the database.  So I need to retrieve 
data on those 3000 files using IN lists or some alternative.

Dave

Shridhar Daithankar wrote:

>On Wednesday 28 May 2003 18:21, Dave Tenny wrote:
>  
>
>>Having grepped the web, it's clear that this isn't the first or last
>>time this issue will be raised.
>>
>>My application relies heavily on IN lists.  The lists are primarily
>>constant integers, so queries look like:
>>
>>SELECT val FROM table WHERE id IN (43, 49, 1001, 100002, ...)
>>    
>>
>
>How do you derive this list of number? If it is from same database, can you 
>rewrite the query using a join statement?
>
>HTH
>
> Shridhar
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>  
>