openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maia Kozheva (JIRA)" <>
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
             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:

View raw message