[EMAIL PROTECTED] wrote:
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.
I'm running against 3 different databases. With Oracle and MySQL IN
clause performance is satisfactory. With Derby it is not and its much
faster to retrieve each row individually, which seems to indicate that
something is amiss.
Tim
------------------------------------------------------------------------
*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
