|
Re: SQLServer pagination [message #556730 is a reply to message #556536] |
Thu, 02 September 2010 13:17 |
|
Pagination support was added to a lot of the database platforms, but not yet to SQL Server. Please log a bug for this and vote for it.
The syntax appears to be something like,
SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY name) as row FROM sys.databases ) a WHERE row > 5 and row <= 10
If you want to give implementing it a try attach your patch to the bug. Or ask for any help here if you run into an issue.
Without the platform SQL support, EclipseLink will use the JDBC maxRows API which will limit the fetch of the rows and is quite efficient. However for the start row EclipseLink will need to scroll the ResultSet to that position, which depending on the JDBC driver may be less efficient than using platform specific SQL.
James : Wiki : Book : Blog : Twitter
|
|
|
Powered by
FUDForum. Page generated in 0.02570 seconds