How do you detect N+1 in MVC list pages?
PICTURE THIS: DATABASE INDEX
Simple meaning
SQL logging or MiniProfiler shows repeated queries in loops.
WHY — Performance instead of guessing?
Why interviewers care about Performance:
question about Performance.
trade-offs, and what you would actually do on a .NET MVC project - not buzzwords.
Name the idea, why it exists, then one short example.
End with when you use it and one common pitfall.
STEPS — What happens step by step?
Before you speak the answer, walk the interviewer through these steps:
- 1SQL logging or MiniProfiler
shows repeated queries in loops.
- 2Why it exists
Prefetch or project to DTOs.
- 3Views should not query
the database.
- 4Give an example
One tiny concrete case you can say aloud.
- 5Common mistake
What juniors usually get wrong.
- 6Close
When you pick this over the alternative.
EXAMPLE — See it in action
Here's a short line you can speak, broken into clear beats:
Note: Adapt this scaffold to your own project — keep it under 60–90 seconds.
Key takeaway
SQL logging or MiniProfiler shows repeated queries in loops. Prefetch or project to DTOs.