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