db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4227) performance degradation of with simple queries & no data retrieval
Date Wed, 13 May 2009 00:32:45 GMT
performance degradation of with simple queries & no data retrieval

                 Key: DERBY-4227
                 URL: https://issues.apache.org/jira/browse/DERBY-4227
             Project: Derby
          Issue Type: Bug
    Affects Versions:,
            Reporter: Myrna van Lunteren

I have been executing some non-contributed (and not easily contributable) performance tests,
and found that across the board, with the exception of some blob streaming and complicated
queries, performs significantly worse from

I've turned one of these tests into a little repro script.
It's decidedly hokey, but if you execute this repeatedly (removing the wombatC db and derby.log
each time) you'll likely find the same. I executed this on an MS-Windows 2000 machine, with
ibm 1.5. jvm.

As a quick comparison, I got the following data out of executing the repro 4 times with a
fairly recent build (706492),, and Time is the elapsed time printed
out at the  end by the repro.

1st run      187               219             328
2nd run     172               172             328
3rd run       203              234             313
4th run       187               281            344

We should identify why a simple select without actually fetching the data would do so much
worse with

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message