Is there a more efficient way of making pagination in Hibernate than executing select and count queries?

by

Baron Schwartz at MySQLPerformanceBlog.com authored a post about this. I wish there was a magic bullet for this problem, but there isn’t. Summary of the options he presented:

  1. On the first query, fetch and cache all the results.
  2. Don’t show all results.
  3. Don’t show the total count or the intermediate links to other pages. Show only the “next” link.
  4. Estimate how many results there are.

More Related Contents:

  1. HQL – row identifier for pagination
  2. What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate
  3. Hibernate 5 :- org.hibernate.MappingException: Unknown entity
  4. Using Hibernate’s ScrollableResults to slowly read 90 million records
  5. The server time zone value ‘AEST’ is unrecognized or represents more than one time zone
  6. Unable to get spring boot to automatically create database schema
  7. Hibernate: Automatically creating/updating the db tables based on entity classes
  8. Hibernate criteria: Joining table without a mapped association
  9. No Dialect mapping for JDBC type: 1111
  10. How can you call custom database functions with Hibernate?
  11. @GeneratedValue polymorphic abstract superclass over MySQL
  12. Can Hibernate work with MySQL’s “ON DUPLICATE KEY UPDATE” syntax?
  13. Spring, Hibernate, Blob lazy loading
  14. How can I use MySQL assign operator(:=) in hibernate native query?
  15. Enum in Hibernate, persisting as an enum
  16. Hibernate Criteria Query to get specific columns
  17. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed
  18. Hibernate HQL Query : How to set a Collection as a named parameter of a Query?
  19. How to escape reserved words in Hibernate’s HQL
  20. Invalid syntax error “type= MyISAM” in DDL generated by Hibernate
  21. Hibernate: Create Mysql InnoDB tables instead of MyISAM
  22. IN-clause in HQL or Java Persistence Query Language
  23. HQL Hibernate INNER JOIN
  24. HQL left join of un-related entities
  25. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  26. com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source
  27. How to write a like query in HQL
  28. Hibernate Criteria API: get n random rows
  29. Inserting data in one table using HQL in Hibernate
  30. Make hibernate backquote all table / column names

Leave a Comment