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

    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-1.diff
          22 kB
          Knut Anders Hatlen
        2. derby-2597-1.stat
          0.4 kB
          Knut Anders Hatlen
        3. derby-2597-2.diff
          2 kB
          Knut Anders Hatlen
        4. derby-2597-3.diff
          10 kB
          Knut Anders Hatlen
        5. derby-2597-3.stat
          0.6 kB
          Knut Anders Hatlen

        Activity

          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: