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

Support SQL server Offset Fetch syntax for pagination

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment