Spaces:
Running
Running
Commit History
-
Comprehensive performance overhaul: eliminate ALL correlated subqueries with CTEs, add 6 composite indexes, add TTL cache, fix N+1 patterns in viral/search/artist endpoints, remove duplicate font import, add lazy loading
Vaibhav PharmacyChanges: - api/main.py: Rewrote 17 correlated subqueries across 8 endpoints with CTE/JOIN patterns - api/metrics.py: Replaced per-cycle loop with GROUP BY, added enrich_viral_alerts_bulk - collector/db.py: Added 6 composite indexes + auto-creation on import - api/cache.py: New TTL cache module for expensive responses - frontend: Fixed toggleWatch re-fetching, added lazy loading, removed duplicate font import689e51a