Hibernate — The Cartesian Product Problem with Paginated Queries
summary
The talk analyzes the Cartesian product problem that appears in Hibernate queries, especially when using pagination. It explains when this problem arises, why an apparently obvious fix can be suboptimal, reports a Hibernate 6 bug the presenter found (with its cause and relation to the Cartesian-product issue), and compares several solutions with their pros and cons.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 3:54Pagination problem in Hibernate
- 7:10Standard solutions and pitfalls
- 13:38Hibernate bug discovery
- 17:15Cartesian product problem
- 19:29BatchSize solution
- 26:30Alternative: separate queries
- 36:16Summary
- 38:41Q&A
related talks
58mCause of Death: Hibernate.
52mHibernate performance tuning
01h 05mJPA Puzzlers (+Hibernate and Spring)
45mLazy Versus Eager Loading Strategies for JPA 2.1
16mCause of Death: Hibernate
53mHibernate you know it… but actually you don’t
49mPerformance oriented Spring Data JPA & Hibernate
52mJava Persistence and Hibernate Tips that can boost up your application performance