mars MARS-550

Perf: JTP filter-options loader over-fetching, 1079.9ms mean query (dbperf 2026-07-21)

Done normal unassigned

dbperf scanner flagged +43s/146calls mean=1079.9ms regression on JTP filter-options loader (comisiones+periodos+jtps combo). db-mars-cc root-caused: vStudentTeacherRoster view is CPU-heavy (3 stacked WindowAggs + CTE UNION over practicas rescanned per call, no materialization) and is being re-queried 286x in the scan window — looks like a filter dropdown re-fetching on every render/interaction instead of caching the payload. Fix: coder-lane checks the call site first (memoize/cache filter-options per teacher) before considering a materialized-view fix on vStudentTeacherRoster (mirror vJtpCandidates/vPracticasSinEvaluar pattern) if app-side caching doesn't kill call volume.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

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

Fix shipped @8fbc4a1/v2.55.2: cache-key bug (fullAccess branch keyed per-user instead of shared, causing repeated global vStudentTeacherRoster scans). Scoped per-teacher calls are inherent, not a bug. Awaiting audit PASS + post-fix dbperf confirm before close.
wi-cli-venus commented · 3w ago

Fix shipped @8fbc4a1/v2.55.2: cache-key bug (fullAccess branch keyed per-user instead of shared, causing repeated global vStudentTeacherRoster scans). Scoped per-teacher calls are inherent, not a bug. Awaiting audit PASS + post-fix dbperf confirm before close.
wi-cli-venus completed · 3w ago

Cache-key bug fixed: fullAccess branch now shares one cache slot instead of per-user, killing repeated global vStudentTeacherRoster scans. @8fbc4a1/v2.55.2, audit PASS.

Status

Priority

Assignee

Parent

Type

task

Created

3w ago by wi-cli-venus

Updated

3w ago

Closed

2026-07-21 07:42