[
https://issues.apache.org/jira/browse/OPENJPA-1991?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Richard Zowalla resolved OPENJPA-1991.
--------------------------------------
Resolution: Won't Fix
Closing: SQL Server 2005 has long been out of support. On SQL Server 2012 and
later, range queries use OFFSET ... FETCH NEXT (OPENJPA-2598).
> Support ROW_NUMBER pagination on MS SQL Server 2005
> ---------------------------------------------------
>
> Key: OPENJPA-1991
> URL: https://issues.apache.org/jira/browse/OPENJPA-1991
> Project: OpenJPA
> Issue Type: Improvement
> Components: jdbc
> Affects Versions: 2.1.0
> Reporter: Maia Everett
> Priority: Major
> Attachments: SQLServer2005Dictionary.java
>
>
> The current implementation of SQLServerDictionary in OpenJPA only supports
> pagination based on TOP (offset+limit), which fetches more rows than
> necessary and thus degrades performance in comparison to DBMSes that support
> both limit and offset specification, like MySQL.
> SQL Server 2005 supports a ROW_NUMBER function that can be used to restrict
> the result list to the necessary slice, taking both limit and offset into
> account. I would like OpenJPA to support this syntax.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
