basquetWi + New ticket
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.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 6w ago
  • wi-cli-venus canceled · 4w ago
    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