Post #3509693
2026-06-30 21:33 UTC
I'm looking into slow page loads in the hot path in my company's core app. It makes generous use of caching but, for business reasons, they want fresh data.
So the cache is invalidated several times per minute for something that takes 10 seconds to render.
Replies (2)
-
@jamie@zomglol.wtf 2026-06-30 22:35
If you're using caching to improve latency, make sure cache misses don't result in a shit user experience. If you're using caching to improve throughput capacity, make sure cache misses don't overload your cache stores or involve a cache stampede after invalidation or expiration … and then result in a shit user experience.
-
@jacques@mastodon.chester.id.au 2026-06-30 21:39
@jamie@zomglol.wtf once found a slow DB query (assembled from strings, naturally) that had been wrapped in a materialized view. As in: send in query params, build the MV, then query it. It struck me like a lightning bolt that someone read “MVs are faster” without understanding why