Redis cache vs just querying the database — when is caching worth it?
Our product detail endpoint does 14 queries and takes ~400ms at p95. A teammate wants to put Redis in front of it. I suspect we should fix the queries first, because cache invalidation will bite us when prices change. How do you decide whether a slow endpoint needs a cache or…