QUERY PATTERNS
Every query was fast.
The page took 4s.
401 QUERIES, ALL OF THEM QUICK
You loaded 400 rows, then touched
something attached to each one.
N+1
ONE PER ROW
The ORM fetches each row on its own, one round trip per row.
EAGER LOAD
ONE ROUND TRIP
One trip brings all of it back, in a bigger result set.
N+1 — one query per row.
401 fast trips, one slow page.
EAGER LOAD — one query for all.
One trip, a bigger result.
Every query was fast.
The page took 4s.
You'll want this one
in your query log.
