[
https://issues.apache.org/jira/browse/OPENJPA-2598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on OPENJPA-2598 started by Francesco Chicchiriccò.
-------------------------------------------------------
> 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)
