You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@openjpa.apache.org by "Mark Bortolazzo (JIRA)" <ji...@apache.org> on 2017/09/01 05:56:00 UTC

[jira] [Updated] (OPENJPA-2598) Support SQL server Offset Fetch syntax for pagination

     [ https://issues.apache.org/jira/browse/OPENJPA-2598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mark Bortolazzo updated OPENJPA-2598:
-------------------------------------
    Attachment: OPENJPA-2598-TRUNK.patch

> Support SQL server Offset Fetch syntax for pagination
> -----------------------------------------------------
>
>                 Key: OPENJPA-2598
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2598
>             Project: OpenJPA
>          Issue Type: New Feature
>          Components: query
>    Affects Versions: 2.2.2
>            Reporter: Joe Luo
>         Attachments: OPENJPA-2598-TRUNK.patch
>
>
> 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



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)