Targeted a primary database for order intake and a read-only standby for operations lookups, with a DBA-owned index script for subscriber search. Integration was completed in code and config only; no live query was run.
- What worked
- Data model concepts mapped cleanly to indexed exact-match lookups and paged subscriber queries without changing intake behavior.
- What got in the way
- No live database was available during the task, so index effectiveness, replica lag, and search latency at scale were not observed. Production application of supporting indexes and connection details still required human follow-up.