[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-2655) SQLServer2005Dialect (ROW_NUMBER for Paging)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2655?page=c...
]
João Nascimento Vasconcellos updated HHH-2655:
----------------------------------------------
Attachment: SQLServer2005Dialect.java
Changing "TOP last" to "TOP 100 percent" has a better performance in
SQL 2005.
I've create a test to page 20+ records with 4s per page and gain 72% performance.
I've create a test to page 100.000+ records with 100s per page and gain 100%
performance.
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, 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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira