db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5524) Speed up clean-up after StatementJdbc30Test.xtestMaxOpenStatementsWithQueryTimeout
Date Wed, 07 Dec 2011 13:40:41 GMT

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

Knut Anders Hatlen updated DERBY-5524:

    Attachment: d5524.diff

Attaching the patch d5524.diff which disables auto-commit for xtestMaxOpenStatementsWithQueryTimeout.
The time to run the test case is reduced from 230 sec to 30 sec in my environment when the
patch is applied.
> Speed up clean-up after StatementJdbc30Test.xtestMaxOpenStatementsWithQueryTimeout
> ----------------------------------------------------------------------------------
>                 Key: DERBY-5524
>                 URL: https://issues.apache.org/jira/browse/DERBY-5524
>             Project: Derby
>          Issue Type: Improvement
>          Components: Test
>    Affects Versions:
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>            Priority: Minor
>         Attachments: d5524.diff
> StatementJdbc30Test.xtestMaxOpenStatementsWithQueryTimeout takes close to four minutes
in my environment. It turns out it spends most of the time in tearDown() closing statements.
> The test case opens a lot of statements (more than 16000) on the same connection and
keeps them open until the test has completed, to verify that it is possible to have that many
open statements on a single connection when a query timeout has been specified. The test case
runs with auto-commit enabled, and every call to Statement.close() in tearDown() therefore
results in an implicit commit. When committing a transaction, the engine needs to go through
the list of activations in that transaction. Since there's one activation per open statement,
that list is pretty long. Although it gets shorter for each statement that is closed, it takes
a while to get through all the statements (~16000^2/2 activations need to be checked before
all statements are closed...).
> This can easily be fixed by disabling auto-commit for the test case. Since no (implicit)
commit happens during the test case itself, this doesn't change the semantics of the test
case. It will speed up the closing of the statements in tearDown() because it will no longer
run 16000 implicit commits and traverse the long list of activations 16000 times.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message