1. Hibernate pagination performance problem coderanch.comHere is the main part of page class code .....in my application. public class Page { private List results; private int pageSize; private int page; private ScrollableResults scrollableResults; private int totalResults = 0; /** * Construct a new Page. Page numbers are zero-based, so the * first page is page 0. * * @param query * the Hibernate Query * @param ... |
2. Hibernate/Display tag Pagination (Poor/slow performance for the last set of pages)/ Oracle 10 G coderanch.comI'd be going right to the database side to find points of optimization. Creating some type of View might be good. You've definitely got to have an index. Maybe even accessing data through a stored procedure. With a million records, you've got to start pulling out some serious database side optimizations. -Cameron McKenzie |
3. Paging strategies - performance forum.hibernate.orgHi i read some posts & articles and still i cant find the best approach in paging with hibernate.(or I found one but i cant find why) Lets consider example (common) problem: In web appication user have form where can specify few query criteria , after search hi recives a search results paginated in to few pages (search result are large). ... |
4. paging performance problem forum.hibernate.orgHi, I have performance problem using hibernate's paging strategy(setFirstResult() and setMaxResults()) with Oracle DB. The first 10 records is fast, but when I want to view the records with rownum between 2000 and 2010 is very very slowly. I looked at the Sql generated, and this script is coming slowly when the rownum is big: select * from ( select row_.*, ... |
5. Paging Performance forum.hibernate.orgHi all, Im using Hibernate 2.1.4 with Oracle 9i. I have a table with 200000 rows thats represented by bean Card and a table with 200000 rows represented by bean Carrier. Im using paging of Hibernate like this: Code: query += "select distinct c from Card c" + " left join fetch c.cardStatus cs" ... |