We are experiencing some performance problem with a Derby DB.
To make short we have a table with the following columns :
clientId | callRef | callStart | callEnd | contact | .... and some others
The primary key is : (clientId, callRef).
I'm trying the following request :
SELECT * FROM CALLCDRACD WHERE clientId='xxxx' ORDER BY CALLSTART OFFSET 10
ROWS FETCH NEXT 20 ROWS ONLY
The request is executed during 15 sec with this table containing 460 000
entries (seems a lot of time).
I've added the following index : CREATE INDEX IND_CCA_CALLSTART ON
APP.CALLCDRACD(CLIENTID,CALLSTART) but now the request took approximatively
the same time to be processed... My index seems to have no effects.
We made and other test using mySQL and the same DB configuration, mySQL
returns the results within 200ms
Does someone have any explanation about this 15 sec required to process the
request on a derby DB.
--
View this message in context: http://old.nabble.com/Performance-problem-with-derby-tp32364853p32364853.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
|