Backlog: Fix Performance Issues

TL;DR

Investigate and resolve performance issues in the Contract Management System to ensure acceptable load times and system responsiveness.

Description

• Problem / user story: The system is experiencing performance issues — slow page loads, queries, or processing — that degrade the user experience.
• Context / constraints: ClickUp umbrella SYS-1970 with enumerated children in [[Projects/anabatic-contract-management-system/context/sys-1970-cms-performance-issues-breakdown]]; technical evidence in [[Projects/anabatic-contract-management-system/reports/backend-cover-letter-query-performance-audit]].

Acceptance Criteria

• Performance bottlenecks identified and documented
• Fix(es) implemented and verified against baseline
• Key interactions meet agreed response-time targets
• No regression introduced to existing functionality

Priority

• Priority: p1
• Rationale: Performance issues directly affect usability and adoption of the system.

Dependencies

• Blocks: —
• Blocked by: —
• Related ADR: —

Links

• Project context: [[Projects/anabatic-contract-management-system/context/index]]
• Parent perf epic (ClickUp): SYS-1970 — Performance Issue on CMS
• Child breakdown: [[Projects/anabatic-contract-management-system/context/sys-1970-cms-performance-issues-breakdown]]
• Evidence / remediation: [[Projects/anabatic-contract-management-system/reports/backend-cover-letter-query-performance-audit]]
• SYS-2022 execution: [[Projects/anabatic-contract-management-system/context/clickup-execute-sys-2022-2026-05-13]]
• SYS-2022 backlog stub: [[Projects/anabatic-contract-management-system/backlog/p1-sys-2022-cover-letter-join-cardinality]]
• SYS-2047 (Redis SLA): [[Projects/anabatic-contract-management-system/backlog/done/p1-sys-2047-redis-sla-cache]]
• Design / Spec:
• Ticket / Issue: umbrella for SYS-1970 children — prefer child tickets in ClickUp

Notes

• Profiling / investigation should precede any fix to avoid optimising the wrong layer.