Hello, fellow Derby users
I have a table like
this:
CREATE TABLE Things
(
thingIdx
BIGINT NOT NULL GENERATED
ALWAYS AS IDENTITY,
thingName
VARCHAR(80) NOT NULL,
...
// bunch of other columns not relevant to my
problem
CONSTRAINT Things_PK PRIMARY KEY (thingIdx)
)
I find that
I believe that this is a known Derby defect.
Does anyone know if this is fixed in the
upcoming release?
From: Christine
Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20,
2006 3:48 PM
To: Derby
Discussion
Subject: Performance of IN
operator
Hello
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
From: Bryan Pendleton [EMAIL PROTECTED]
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