ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #hibernate
Stop overloading your JVM memory. Learn how to implement efficient server-side pagination in Spring Data JPA using Pageable, Page, and Slice to handle large datasets.
Move pagination and filtering to the database with Hibernate Criteria API. Learn the fetch-join trap, deep-paging fixes, and a verification checklist that prevents production surprises.
Learn how JHipster uses Spring Data JPA's Pageable interface to implement server-side pagination, preventing memory overflows and optimizing database queries for large datasets.
Deep offset pagination with Hibernate slows linearly as OFFSET grows. Use keyset pagination with a WHERE clause on the last seen sort key and a suitable index for stable page times.
Learn how Hibernate's setFirstResult and setMaxResults enable offset pagination, why they degrade on big tables, and how to switch to key‑set pagination for scalable queries.
Stop using setFirstResult() for deep pagination in Hibernate. Learn why offset-based pagination slows down and how to implement the Keyset (Seek) method for constant-time performance.
Stop letting deep pagination kill your database performance. Learn why offset-based pagination slows down and how to implement Keyset-based pagination in Hibernate for constant-time lookups.
Spring Data JPA offers Page<T> and Slice<T> for pagination. This post explains the SQL differences, performance trade‑offs, and how to pick the right option for large tables and infinite‑scroll UIs.
Learn how to solve deep pagination performance bottlenecks in Hibernate by comparing offset and keyset pagination with implementation examples, operational checks, and guidance on when to switch.
spring
java
jhipster