mars MARS-560

JTP filter-dropdown query 624ms->3ms: lean vComisionPickedTeachers view replaces heavy roster-view subquery

Done normal unassigned

dbperf residual after MARS-550 (cache-key fix): the jtps/comisiones filter-options subqueries recompute vStudentTeacherRoster (deep CTE + 3 window stages + LATERAL) and vTeacherComisionMemberships (6-table mega-join) every call = 624ms mean/119 calls. db-mars-cc analysis: NOT a matview case (roster derives from hot práctica write table → refresh fires constantly; overkill at users=445/TCM=262). Fix = canonical lean view vComisionPickedTeachers: (practicas jtpUserId) UNION (studentAssignments assignedTeacherUserId) JOIN active users, scope via BASE teacherComisionMemberships. Server-side 2ms (~90x). Decision (a) exact-parity chosen (replicate sa_fallback NOT-EXISTS guard, byte-identical dropdown); (b) simplified superset +2 assigned-but-overridden JTPs flagged to Elazar as optional non-blocking ruling. db authors view, coder repoints both subqueries. Class-S.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 3w ago
wi-cli-venus completed · 3w ago

Repointed JTP+comisión filter subqueries onto db's lean vComisionPickedTeachers (mig 089) + base teacherComisionMemberships for scope — 624ms→26ms, byte-identical dropdown (option a). @71c0ff2/v2.58.4, Class-S self-PTD PASS, auth gate untouched. Option (b) superset flagged to Elazar as optional.
wi-cli-venus blocked · 3w ago

audit BLOCK:71c0ff2 — P2-A (code, soft-delete invariant on scope-view swap) fixed; P2-B (mig 089 owner-rights vs mig-086 security_invoker rule) routed to db-mars-cc → followup mig 090. Coder re-bundles 090+code fix into one re-push. Prod 2.58.4 functionally correct meanwhile (grantees hold base SELECT; hardening gap not active leak).
wi-cli-venus completed · 3w ago

JTP filter-picker repointed onto db's lean deterministic vComisionPickedTeachers (mig 089 + 090 security_invoker) — 624ms→~21ms, byte-identical output, scope/soft-delete invariants preserved. @3e2ff21/v2.58.5, audit PASS:3e2ff21.
wi-cli-venus completed · 3w ago

JTP filter-picker repointed onto db's lean deterministic vComisionPickedTeachers (mig 089 + 090 security_invoker) — 624ms->~21ms, byte-identical output, scope/soft-delete invariants preserved. @3e2ff21/v2.58.5, audit PASS:3e2ff21.