Derby
  1. Derby
  2. DERBY-5695

Speed up population of tables in OrderByAndSortAvoidance

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.9.1.0
    • Fix Version/s: 10.9.1.0
    • Component/s: Test
    • Labels:
      None

      Description

      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.

      1. d5695-1a.diff
        648 kB
        Knut Anders Hatlen

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12663126 ] Default workflow, editable Closed status [ 12796651 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Knut Anders Hatlen made changes -
          Link This issue breaks DERBY-5733 [ DERBY-5733 ]
          Knut Anders Hatlen made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Fix Version/s 10.9.0.0 [ 12316344 ]
          Resolution Fixed [ 1 ]
          Knut Anders Hatlen made changes -
          Attachment d5695-1a.diff [ 12523340 ]
          Knut Anders Hatlen made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Knut Anders Hatlen made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-4409 [ DERBY-4409 ]
          Knut Anders Hatlen created issue -

            People

            • Assignee:
              Knut Anders Hatlen
              Reporter:
              Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development