Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-827 Performance can be improved by re-using language ResultSets across Activation executions.
  3. DERBY-2597

Language result sets should not reuse current isolation level across executions

Attach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.3.1.4
    • 10.3.1.4
    • SQL
    • None
    • Performance

    Description

      Some of the language result sets cache the current isolation level in their constructors. To allow reuse of the result sets, they should check the isolation level each time they are opened. Currently, this affects HashScanResultSet, TableScanResultSet, LastIndexKeyResultSet and UpdateResultSet (and their sub-classes).

      Attachments

        1. derby-2597-3.stat
          0.6 kB
          Knut Anders Hatlen
        2. derby-2597-3.diff
          10 kB
          Knut Anders Hatlen
        3. derby-2597-2.diff
          2 kB
          Knut Anders Hatlen
        4. derby-2597-1.stat
          0.4 kB
          Knut Anders Hatlen
        5. derby-2597-1.diff
          22 kB
          Knut Anders Hatlen

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            knutanders Knut Anders Hatlen
            knutanders Knut Anders Hatlen
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment