Several list endpoints depend on filter-heavy queries. Add the missing indexes so HTLC and dispute lookups stay fast as data grows.
Acceptance criteria:
- Identify the slowest filter combinations.
- Add indexes that match the query patterns.
- Verify the indexes do not regress write performance materially.
Several list endpoints depend on filter-heavy queries. Add the missing indexes so HTLC and dispute lookups stay fast as data grows.
Acceptance criteria: