The new version of Hibernate 4.1.5.SP1 contains a performance problem in pagination using SQL Server 2005.

When we are handling a large amount of data, paging performance decreases significantly as we navigate on the pages.

The query generated for paging, brings all objects in the table (the most extreme case, the last page), only then filter the page data based on rownumber.

When we are working with millions of records is not acceptable to use pagination.