db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4233) Lower tablescan performance right after database creation in 10.5
Date Fri, 22 May 2009 18:05:45 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Mike Matrigali updated DERBY-4233:

Not sure what is going on here, but wanted to comment on the next+fetch -> fetchNext()
change.  The fetchNext() interface was specifically added (a long time ago) as a performance
enhancement and is definitely  preferred whenever it can be substitued for a next + fetch
It saves both procedure calls, code execution and number of times latches are required.

If someone wants to do more work on this one, it does seem likely this is some sort of jit
issue.  So maybe experimenting with setting jvm options that start jit'ing earlier on both
before and after change may show up something.

> Lower tablescan performance right after database creation in 10.5
> -----------------------------------------------------------------
>                 Key: DERBY-4233
>                 URL: https://issues.apache.org/jira/browse/DERBY-4233
>             Project: Derby
>          Issue Type: Bug
>          Components: Performance, SQL
>    Affects Versions:
>         Environment: Solaris Express Community Edition snv_114 X86
> java version "1.6.0_13"
> Java(TM) SE Runtime Environment (build 1.6.0_13-b03)
> Java HotSpot(TM) Server VM (build 11.3-b02, mixed mode)
>            Reporter: Knut Anders Hatlen
>            Priority: Minor
> I noticed that a table scan test performed significantly worse
> (10-20%) in Derby than in Derby I only see this if
> the test creates and populates a fresh database. To reproduce, put
> derbyTesting.jar from and derby.jar from the release you want
> to test in your classpath, and execute the following shell commands:
> # make sure the database is removed so that we create a fresh one
> test -d db && rm -rf db
> # run test for five minutes (+ one minute warm-up)
> java -server -Dderby.storage.pageCacheSize=25000 \
>     org.apache.derbyTesting.perf.clients.Runner \
>     -load sr_select -load_opts nonIndexed -wt 60 -rt 300 -init

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

View raw message