Uploaded image for project: 'Pivot'
  1. Pivot
  2. PIVOT-617

Optimize performance of ResultList

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.5.2, 2.0
    • Component/s: wtk
    • Labels:
      None

      Description

      On at least one JDBC driver, returning a 10,000-row result set using ResultList typically takes 75-85s, whereas retrieving the same data using ResultSet takes only 10s. Optimize performance of ResultList so it is on par with direct ResultSet access.

      Note that this will constitute an API change and slight loss of functionality (ResultList's iterator will only support forward-scrolling iteration, whereas previously it had supported bi-directional iteration). However, the performance benefits for the common case (forward-scrolling) should far outweigh the loss.

        Attachments

          Activity

            People

            • Assignee:
              gbrown Gregory K. Brown
              Reporter:
              gbrown Gregory K. Brown
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: