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

Support SQL server Offset Fetch syntax for pagination

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.2.2
    • 2.4.3, 3.0.0
    • query
    • 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

        1. OPENJPA-2598-TRUNK.patch
          2 kB
          Mark Bortolazzo

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: