db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <de...@segel.com>
Subject RE: Perfroamnce of IN ( ... list ... ) statements
Date Sun, 05 Oct 2008 22:35:28 GMT
There was an issue with earlier versions of Derby, that was supposed to have
been fixed.


Even so, the performance of the IN clause where you have a large list is
going to be an issue in most databases.




From: Peter Ondruška [mailto:peter.ondruska@gmail.com] 
Sent: Sunday, October 05, 2008 3:12 PM
To: Derby Discussion
Subject: Re: Perfroamnce of IN ( ... list ... ) statements


What Derby version is it?

How does it perform if you re-create index on foo_id column?



On Sun, Oct 5, 2008 at 10:07 PM, Tim Dudgeon
<tdudgeon@informaticsmatters.com> wrote:

If I run a statement like this is Derby:
SELECT COL1, COL2 FROM FOO WHERE FOO_ID IN ( 1, 31, ..... 4567)
it seems unexpectedly slow. Its actually faster to retrieve each row
individually using a for loop that it is to use the IN ( ..  list ... )
clause. This seems strange.




View raw message