When I have complicated query results to cache, I usually go for Redis.

hey everyone, im wrestling with caching strategies for some complex, multi-join database queries in a high-traffic application. weve tried basic object caching, but cache invalidation is becoming a nightmare. for those whove scaled similar systems, what patterns or tools do you find most effective for caching the results of complex queries without creating tons of stale data? looking for practical advice and maybe some war stories!