ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #hibernate
Offset pagination makes Hibernate harvest jobs slower with every page. Keyset (cursor) pagination keeps batch cost flat — here's how to implement it, when scroll() fits better, and how to verify the fix.
How Hibernate's setFirstResult and setMaxResults implement database-level pagination, with a worked JPQL example, count-query guidance, the large-offset performance trap, and when to switch to keyset pagination.
Learn how to solve the 'deep paging' performance problem in Hibernate by replacing offset-based pagination with Keyset Pagination and using StatelessSession for bulk reads.
A diagnostic workflow for Hibernate N+1 selects on paginated endpoints: confirm the query count, identify the triggering association, and apply JOIN FETCH, two-query pagination, or entity graphs without falling into the in-memory pagination trap.
Learn when to use GORM versus Native SQL in Grails. This guide compares performance, maintainability, and implementation for data-intensive operations.
A diagnostic guide for Spring Data JPA LazyInitializationException: recognize the condition, trace the transaction boundary, use a cause table, ordered checks, targeted fixes (fetch joins, DTOs, open-in-view), and escalation criteria for pagination and async paths.
Offset pagination in Hibernate gets slower with every page. Cursor (keyset) pagination fixes it with a WHERE clause on the last seen ID — here's how to implement it, avoid the N+1 and stability traps, and verify the win.
Learn how to diagnose and fix the HHH000104 warning in Hibernate, which causes dangerous in-memory pagination when using JOIN FETCH with collections.
Learn how to define and execute paginated named queries in Hibernate. This article walks through the exact configuration, execution, and common pitfalls, so you can fetch large datasets efficiently and safely.
java
norg
xd
npss