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 Kozheva
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 is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
