[EMAIL PROTECTED] wrote:
There was an issue with earlier versions of Derby, that was supposed to
have been fixed.
You are right. I tested with Derby 10.4 and it now looks much better.
Sorry for the confusion.
Tim
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:[EMAIL PROTECTED]
*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?
p.
On Sun, Oct 5, 2008 at 10:07 PM, Tim Dudgeon
<[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> 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.
Thanks
Tim
