Connection Management and the N+1 Trap

We built an ORM that generates SQL. Today we connect it to a real database — and discover why naive ORMs destroy performance before you notice.

I once watched a single page load trigger 847 database queries.

It wasn't a bug. There were no errors, no exceptions, no timeouts. The page loaded in about four seconds, which felt slow but not broken. A customer list with their recent orders. Simple enough.