Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

ADR-004: Batched relation loading, not JOINs

Date: 2026-08-13
Status: Accepted

Decision: one query per relation level.

Why: see the comparison table in ImplPlan06 P5-03. JOINs cause row explosion, make per-relation take and filter hard, and require de-duplication.

Cost: more round trips than a single JOIN for shallow queries. Acceptable — the count is bounded by schema depth, not data size.