Should the first dashboard read live records or a derived snapshot?
- Query the authoritative records when the user opens or filters the dashboard
- Read a precomputed summary refreshed by a scheduled or background job
Choose: Start with a live server query for a bounded record set when it meets the response target. Move only expensive, measured aggregations to a versioned derived snapshot with explicit freshness and reconciliation.
Tradeoff: Live queries reduce stale-state complexity but can become slow or costly. Derived summaries improve predictable reads but introduce lag, rebuilds, definition versions, partial failure, and another result that must be reconciled.
