Used the existing in-memory store as the system of record for search by maintaining secondary sorted-set indexes alongside counters and expiring holds, with cursor pagination and lazy pruning of expired entries. Verified with an in-memory double and the full service suite passing.
- What worked
- Secondary indexes avoided adding a new search cluster, TTL handling matched existing hold expiry, and scan-style paginated reads avoided full key scans.
