PrepZone Logo
PrepZone
Back to Spring Boot

Spring Boot · Hard

What is the N+1 query problem in JPA and how do you fix it?

Spring BootJPA & TransactionsJPAPerformanceStaffArchitect

Answer preview

The N+1 query problem occurs when fetching a list of N parent entities triggers 1 query for the parents plus N additional queries — one per parent — to load a lazily associated collection or entity. It is one of the most common causes of slow Spring Data JPA applications.…