db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (Resolved) (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DERBY-5695) Speed up population of tables in OrderByAndSortAvoidance
Date Fri, 20 Apr 2012 11:30:41 GMT

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

Knut Anders Hatlen resolved DERBY-5695.
---------------------------------------

       Resolution: Fixed
    Fix Version/s: 10.9.0.0

Committed revision 1328328.
                
> Speed up population of tables in OrderByAndSortAvoidance
> --------------------------------------------------------
>
>                 Key: DERBY-5695
>                 URL: https://issues.apache.org/jira/browse/DERBY-5695
>             Project: Derby
>          Issue Type: Improvement
>          Components: Test
>    Affects Versions: 10.9.0.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>            Priority: Minor
>             Fix For: 10.9.0.0
>
>         Attachments: d5695-1a.diff
>
>
> OrderByAndSortAvoidance executes about 3000 INSERT and UPDATE statements to populate
table1 and table2 in its decorateSQL() method. Since each of the statements has to be parsed
and compiled, this could take quite some time on less powerful hardware.
> There are essentially three kinds of statements, and they could be parametrized like
this:
> INSERT INTO table1 VALUES (?)
> INSERT INTO table2 VALUES (?,?,?)
> UPDATE table2 SET value='true' WHERE id=? AND name='has_address'
> We should parametrize the statements, prepare them once and execute them multiple times
in order to speed up the test.

--
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

        

Mime
View raw message