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

[Ed Wallen (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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

> SQLServer2005Dialect (ROW_NUMBER for Paging)
> --------------------------------------------
>
>                 Key: HHH-2655
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2655
>             Project: Hibernate3
>          Issue Type: New Feature
>          Components: core
>    Affects Versions: 3.2.2, 3.2.3, 3.2.4
>         Environment: SQLServer 2005, Hibernate 3.2.2+
>            Reporter: Wells Tiedeman
>         Attachments: BindingSqlServerDialect.java, SQLServer2005Dialect.java, SQLServer2005Dialect.java, SQLServer2005Dialect.java
>
>   Original Estimate: 1 minute
>  Remaining Estimate: 1 minute
>
> Add a SQLServer2005Dialect class to the product that leverages the new ROW_NUMBER capabilities within SQLServer2005 to do paged result sets more efficiently.  See attached source...

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