ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #hibernate
Offset-based pagination with Hibernate's setFirstResult degrades superlinearly. Cursor-based pagination using a monotonic unique ID and setMaxResults delivers constant-time page loads. Here's how to implement it in JPQL and why it works in Hibernate 5.x and 6.x.
Deep pagination with LIMIT/OFFSET hurts performance. Learn how to replace it with cursor‑based keyset pagination in Hibernate, how fetch strategies interact, and how to validate the change with EXPLAIN plans.
Learn how to choose between Dynamic Finders, Where queries, and Criteria API for pagination in Grails to prevent memory leaks and optimize SQL performance.
Learn how Dropwizard’s HibernateBundle simplifies JPA integration by managing the EntityManagerFactory, injecting request‑scoped EntityManagers, and enabling automatic transactions with @UnitOfWork.
IntelliJ IDEA Ultimate's JPA Console runs JPQL/HQL against your persistence unit without deploying. Set it up safely and use it to verify pagination before wiring queries into repositories.
How Hibernate's setFirstResult/setMaxResults really work, with a worked JPQL example, the collection fetch join trap (HHH000104), total counts, and when to switch to keyset pagination.
Offset pagination (setFirstResult/setMaxResults) scans and discards rows — page 1000 costs far more than page 1. Keyset pagination uses an indexed cursor (WHERE id > lastSeenId) for constant-time seeks, with forward, backward, and composite-cursor Hibernate examples.
Implement efficient server-side pagination in Hibernate 5.2+ and 6.x using the JPA Criteria API (CriteriaBuilder/CriteriaQuery). Avoid OutOfMemoryErrors, understand the collection fetch trap (HHH000104), and verify database-level LIMIT/OFFSET generation.
When dealing with millions of rows in Hibernate, offset‑based paging can choke performance, while cursor‑based paging offers efficient deep navigation. This guide outlines requirements, minimal designs, trust boundaries, operational checks, and failure modes for each strategy.
leetcode
dropwizard
java
norg
jeet