Java · Senior · Theory

What is the N+1 problem in Hibernate, how do you detect it, and what ways do you have of solving it? What are the trade-offs of each approach?

~4 min by voice

How to approach it

This checks whether the candidate understands the mechanics of lazy loading in Hibernate, whether they can find N+1 systematically rather than by the feeling that "the page is slow", and most importantly whether they see the trade-offs of each solution: fetch join, batch fetching, DTO projections, EAGER.

Have you seen this question in a real interview?

Answers0

Avg. score—

Strong—

Practiced0

Topics

jpa hibernate

Similar questions

You notice that the order list page runs hundreds of SQL queries. What could be causing it on the JPA side, and how would you fix it? Mid-level Once a day you need to import a CSV with several million rows into the database through an existing JPA layer. How would you design the import so it doesn't run out of memory and finishes in time? Mid-level Once a day you need to process tens of millions of rows from the database and recompute data based on them, in Java with Spring and JPA. How would you design that processing? Senior Where does LazyInitializationException come from, and how do Hibernate's first-level and second-level caches affect working with entities? Mid-level

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Best with headphones · ~4 min