[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-2655) SQLServer2005Dialect (ROW_NUMBER for Paging)

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2655?page=c... ] Ed Wallen updated HHH-2655: --------------------------- Attachment: BindingSqlServerDialect.java I also found this same problem. I looked at the implementations provided with this ticket but wasn't all that happy with the performance I got out of them, so I wrote a new one (see attached BindingSqlServerDialect.java). This is now deployed in several of my production systems working against database tables with tens of millions of records. It has GREATLY improved the system's performance and efficiency, especially under heavy load. I certainly hope it is included as a part of the Hibernate codebase in the near future. -Ed -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira