Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-818

Read-only embedded ResultSets incur performance penalty due to updateable ResultSet code.

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 10.2.1.6
    • JDBC
    • None
    • Performance

    Description

      The fields columnGotUpdated and copyOfDatabaseRow are allocated and maintained in EmbedResultSet for every ResultSet but they are only required if the result set is updateable. I saw a 5% improvement in execution rate on a simple VALUES clause when fixing this.

      Attachments

        1. derby818patch.txt
          2 kB
          Daniel John Debrunner

        Activity

          People

            djd Daniel John Debrunner
            djd Daniel John Debrunner
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: