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

Posted to dev@openjpa.apache.org by "Francesco Chicchiriccò (JIRA)" <ji...@apache.org> on 2017/09/01 06:42:00 UTC

[jira] [Resolved] (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 ]

Francesco Chicchiriccò resolved OPENJPA-2598.
---------------------------------------------
    Resolution: Fixed

Patch applied as requested: thanks!

> 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
>            Assignee: Francesco Chicchiriccò
>             Fix For: 2.4.3, 3.0.0
>
>         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)