db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christine Johnson" <cjohn...@willowtech.com>
Subject Re: Performance of IN operator
Date Thu, 21 Sep 2006 00:23:02 GMT
From: "Bryan Pendleton" <bpendleton@amberpoint.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Sent: Wednesday, September 20, 2006 3:55 PM
Subject: Re: Performance of IN operator


> > 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.
>
> thanks,
>
> bryan
>
>
>

One of the workarounds may do the job for us.  Thank you very much!

Chris Johnson
cjohnson@willowtech.com



Mime
View raw message