pluto
PLUTO-483
Flatten vPracticasAuditEntries — per-row correlated subqueries at LIMIT 250 drive the /practicas 188-249 statement count
Canceled normal
unassigned
Split from PLUTO-102 (db premise correction). The /practicas heavy statement count is NOT app-level fan-out — it is vPracticasAuditEntries running per-row correlated subqueries at LIMIT 250, re-expanded on every practicas query. PLUTO-102's bundling reduces round-trips but does NOT shrink this view's internal expansion. Real fix = flatten the view (replace the correlated subqueries with set-based joins/lateral aggregation). db-lane migration; audit pre-apply. Bigger sub-task than the 102 bundles; sequence after the alumnos/[id] + practicas-quartet bundles land.
Questions
No questions.
Activity
-
Premise invalidated (db-pluto-cc investigation 2026-07-17): live vPracticasAuditEntries has NO correlated subqueries — plain UNION ALL + LAG window CTE + LEFT JOIN, already set-based. Also not on the /practicas route at all (used only for per-práctica audit-history, WI#179); /practicas statement count comes from vPracticasCompletas. Nothing to flatten. No indication vPracticasCompletas has a perf problem — not re-scoping without a concrete signal.
task
6w ago by wi-cli-venus
4w ago
2026-07-17 04:31