Interview kitsBlog

Your dream job? Lets Git IT.
Interactive technical interview preparation platform designed for modern developers.

XGitHub

Platform

  • Categories

Resources

  • Blog
  • About the app
  • FAQ
  • Feedback

Legal

  • Privacy Policy
  • Terms of Service

© 2026 LetsGit.IT. All rights reserved.

LetsGit.IT/Categories/Spring
Springhard

Spring Data JPA: what is the N+1 problem and how do you reduce it?

Tags
#jpa#hibernate#n-plus-one#performance
Back to categoryPractice quiz

Answer

N+1 is when you load N parent entities and then trigger one extra query per entity (lazy loading). Reduce it with fetch joins, `@EntityGraph`, batching, or redesigning queries to load needed data in fewer round-trips.

Advanced answer

Deep dive

Expanding on the short answer — what usually matters in practice:

  • Context (tags): jpa, hibernate, n-plus-one, performance
  • Lifecycle: what happens at runtime (render/build, request/response, background jobs).
  • Caching: where cache lives, cache keys, how to invalidate without chaos.
  • Security: authn/authz, secrets, attack surface (SSRF/CSRF).
  • Explain the "why", not just the "what" (intuition + consequences).
  • Trade-offs: what you gain/lose (time, memory, complexity, risk).
  • Edge cases: empty inputs, large inputs, invalid inputs, concurrency.

Examples

A tiny example (an explanation template):

// Example: discuss trade-offs for "spring-data-jpa:-what-is-the-n+1-problem-and-how"
function explain() {
  // Start from the core idea:
  // N+1 is when you load N parent entities and then trigger one extra query per entity (lazy l
}

Common pitfalls

  • Too generic: no concrete trade-offs or examples.
  • Mixing average-case and worst-case (e.g., complexity).
  • Ignoring constraints: memory, concurrency, network/disk costs.

Interview follow-ups

  • When would you choose an alternative and why?
  • What production issues show up and how do you diagnose them?
  • How would you test edge cases?

Related questions

Operating Systems
Explain virtual memory and paging.
#virtual-memory#paging#performance
Operating Systems
What is context switching and why is it expensive?
#context-switch#scheduler#performance
JavaScript
What are debounce and throttle and when would you use each?
#performance#debounce
#throttle
MongoDB
Text indexes: when would you use them and what’s a limitation?
#mongo#text-index#search
MongoDB
`$lookup`: what does it do and what is a common pitfall?
#mongo#lookup#aggregation
PostgreSQL
Materialized view vs view: what’s the difference?
#postgres#views#materialized-view