Sub-optimal Pagination with Oracle & Hibernate

There seem to be a bug in Hibernate 3 that results in sub-optimal query if one attempt to fetch one specific portion of the result set, as is the case typcially with pagination. The best-practice to extract one specific page out of the complete result set is to use the ROWNUM keyword with Oracle. The … Continue reading Sub-optimal Pagination with Oracle & Hibernate

Advertisements