v1.60.7 (b007fb9) perf(mi-cursada): /mi-cursada query rewrite — fold KPI counts via COUNT(*) FILTER OVER() + LATERAL for adjuntoName/teeth/imageCount + React cache() on getStudentPracticas

Sub-tickets

Questions

Activity

• system created · 2026-05-03
  wi cli; parent=#174
• system completed · 2026-05-03
  Shipped 2026-05-02. Audit PASS (mars-audit-w-cc-3209) + db EXPLAIN ANALYZE PASS (mars-db-cc-w-3208, 13ms exec, all index scans). 1 RTT saved + N per-row subqueries collapsed. Predicted -1.2s p75 on /mi-cursada (later revised lower since intra-region RTT is ~5-15ms not 100-200ms per audit-3332).