Aggressive query deduplication and cross-subscriber caching #37
Description
Phase: 3 — Growth & Scale (Cost Optimization)
Reduce SerpAPI costs by sharing search results across subscribers:
- Normalize queries before searching (lowercase, trim, dedup synonyms)
- Cache search results in DB per (query, location, date) — share across subscribers
- Reuse popular query results across days with a short TTL for high-volume locations
- Track cache hit rates to measure savings