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.
|Workflow||jira [ 12663126 ]||Default workflow, editable Closed status [ 12796651 ]|
|Status||Resolved [ 5 ]||Closed [ 6 ]|
|Status||In Progress [ 3 ]||Resolved [ 5 ]|
|Fix Version/s||10.9.0.0 [ 12316344 ]|
|Resolution||Fixed [ 1 ]|
|Status||Open [ 1 ]||In Progress [ 3 ]|