[
https://issues.apache.org/jira/browse/OPENJPA-2598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16150077#comment-16150077
]
Mark Bortolazzo commented on OPENJPA-2598:
------------------------------------------
Hi. I have experienced this issue as well. Please find attached a patch.
It would be nice if it could go on a 2.4 release as well as the 3.0 release.
Regards
Mark
> 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)
