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

Optimize performance of ResultList

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.5.2, 2.0
    • wtk
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: