Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-2598

Support SQL server Offset Fetch syntax for pagination

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.2
    • Fix Version/s: 2.4.3, 3.0.0
    • Component/s: query
    • Labels:
      None

      Description

      We are using OpenJPA with SQL Server. Currently, it uses the TOP syntax for pagination. First, it will select the TOP 20. Then, the TOP 40. The pagination get progressively slower as more rows are returned. SQL 2012 now supports Offset Fetch syntax. Could support for this new syntax be added?

      https://technet.microsoft.com/en-us/library/gg699618(v=sql.110).aspx

        Attachments

          Activity

            People

            • Assignee:
              ilgrosso Francesco Chicchiriccò
              Reporter:
              joeluo Joe Luo
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: