Design patterns·Objects and the database between them
you told the query to bring the customers along with the orders, and the hundred and one queries became one.
Eager loading
Also calledeager fetch, join fetch, include
Fetching associated data in the same query as the parent, by join or by a second batched query. It is the fix for N+1 and the cause of the opposite problem: joining several collections at once multiplies rows and can fetch far more data than the page needed. Choosing between them per use case, rather than globally, is the actual answer.