Joe Qiang Luo created OPENJPA-2598:
--------------------------------------
Summary: 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 Qiang Luo
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.3.4#6332)
