Scale Readiness Review

Workflow

1. Establish assumptions: peak req/job rate, batch/file frequency, ledger growth/day, tenant skew, provider limits, retention needs; if unknown, state conservative assumptions.
2. Inspect hot paths: N+1 queries, missing indexes, unbounded list/export/reconciliation endpoints, full-table scans in jobs, large locking transactions, sync work belonging in a job, queue jobs missing retry/DLQ/backpressure, stale-truth caches.
3. Review data growth: partitioning/archival, pagination contracts, tenant isolation, rebuild paths for derived balances/projections, reconciliation strategy for drift.
4. Recommend: covering index/uniqueness constraint, bounded-page batching, outbox/worker for slow effects, idempotency/retry before more concurrency, metrics for queue/latency/failure/drift, a narrow load test.
5. Verify: query plans, unit/integration tests for pagination/batching/idempotency, benchmarks for hot functions, load tests where a harness exists, metrics/logs for visibility.

Output Format

Finding: unbounded reconciliation query can scan all ledger rows.
Impact: batch runtime grows with total history, not daily volume.
Fix: page by posting date and account id; add an index on (...)
Verification: run query plan and reconciliation integration test.