perf: integrate validated SQL selection and batched API cards

Wuast94 commented

2026-10-19 21:46:24 +02:00

Owner

Home and search repeatedly evaluated catalog ownership/ranking and acquired per-card SQL facts. This change selects native candidates with shared set joins, groups NextUp versions once, and renders physical, named and composition cards through the same batch/singleton projection.

Canonical name keys use the existing Rust clean_tag function and transactional writers/startup repair. New append-only migrations 45/46 add the trigram-backed key and generated episode positions. Existing ACLs, ordering, paging, actual source evidence and filesystem freshness remain authoritative; nested compositions retain the complete authorized fallback.

Validation: RUSTFIN_TEST_COMPILER_CACHE=off just gate passed locally on macOS, including the full workspace suite, 145 API tests, 90 Store tests, native media/realtime/shutdown integration, schema comparison, uroman reproducibility, Clippy, advisories/bans and unused-dependency checks. Both commit hooks also passed. No production data or deployments changed.

Rollout: stop old writers before starting this schema generation (Rustfin-only Recreate). Linux amd64 image/CI validation and complete HTTP latency on the actual cluster dataset remain outstanding; isolated SQL measurements are not claimed as whole-page latency. The broader read-projection proposal and DB-owned subtitles are not included.

Implementation, evidence and limits: docs/performance/implementation.md and docs/performance/README.md.

Home and search repeatedly evaluated catalog ownership/ranking and acquired per-card SQL facts. This change selects native candidates with shared set joins, groups NextUp versions once, and renders physical, named and composition cards through the same batch/singleton projection. Canonical name keys use the existing Rust clean_tag function and transactional writers/startup repair. New append-only migrations 45/46 add the trigram-backed key and generated episode positions. Existing ACLs, ordering, paging, actual source evidence and filesystem freshness remain authoritative; nested compositions retain the complete authorized fallback. Validation: RUSTFIN_TEST_COMPILER_CACHE=off just gate passed locally on macOS, including the full workspace suite, 145 API tests, 90 Store tests, native media/realtime/shutdown integration, schema comparison, uroman reproducibility, Clippy, advisories/bans and unused-dependency checks. Both commit hooks also passed. No production data or deployments changed. Rollout: stop old writers before starting this schema generation (Rustfin-only Recreate). Linux amd64 image/CI validation and complete HTTP latency on the actual cluster dataset remain outstanding; isolated SQL measurements are not claimed as whole-page latency. The broader read-projection proposal and DB-owned subtitles are not included. Implementation, evidence and limits: docs/performance/implementation.md and docs/performance/README.md.

Wuast94 added 3 commits

2026-10-19 21:46:25 +02:00

docs: record SQL performance validation and implementation boundaries [skip ci] f0ec83e0a9

perf(db): persist canonical name keys and episode positions 5ad59c76c6

perf(api): use set-based home and search selection with shared card batches

CI / Quality (pull_request) Successful in 26m4s

Details

CI / Build production (pull_request) Successful in 29m18s

Details

2ac2741488

Wuast94 added 5 commits

2026-10-19 23:13:37 +02:00