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.
Sent: Sunday, October 05, 2008
Subject: Re: Perfroamnce of IN (
... list ... ) statements
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 <firstname.lastname@example.org>
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.