openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maia Kozheva (JIRA)" <j...@apache.org>
Subject [jira] [Created] (OPENJPA-1991) Support ROW_NUMBER pagination on MS SQL Server 2005
Date Tue, 03 May 2011 07:18:03 GMT
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

Mime
View raw message