db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Performance of IN operator
Date Wed, 20 Sep 2006 22:55:06 GMT
> SELECT thingIdx, thingName FROM Things WHERE thingIdx IN (?, ?, ?, ?, 
> ... [100 values scattered throughout index])
> performance is pretty slow -- a bit over a minute for 100 records. 

I believe this is DERBY-47 (http://issues.apache.org/jira/browse/DERBY-47),
also logged as DERBY-713 (http://issues.apache.org/jira/browse/DERBY-713).

There are a number of suggestions in those two bug reports for ways to
work around the problem.

I don't believe there is a fix yet, so for the time being it is advisable
to avoid the problem.



View raw message