Files
Dan Sutton c64242702f perf(webapp,run-store): group per-item run reads into batched queries
Several run-ops read paths issued one database query per item where a single
batched query returns the same data: batch results hydrated each member run
separately, the run retrieve endpoint resolved each locked worker version
separately, the dedicated-schema relation hydrator ran per row, and a few
services read runs in per-id loops. These now group into batched reads.

Adds a grouped findRunsByIds to the run store (one residency-partitioned read
for a set of run ids) and routes the presenters and services through it. The
dedicated-schema relation hydrator batches across all rows per relation. The
waitpoint connected-runs read also regains its display limit at the fetch, so
it no longer loads every connected run into memory before slicing to five.
2026-07-09 15:14:55 +01:00
..