[
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
