20 discussions in the community
we're currently running with a redis cache, but even with high hit rates, the 1-2ms network latency for every cache read still adds up, especially for...
we're currently trying to optimize a 'friends of friends' style query that's taking 10+ seconds with recursive cte's in postgres, and it's just not cu...
we're exploring a multi-level caching strategy for some of our ml inference results: an l1 cache (in-process memory) for the hottest keys, backed by a...
we're using read replicas extensively to scale our postgresql database, which has been great for offloading read traffic. the problem we're consistent...
we have a public product catalog api handling about 100k requests per minute, and the underlying data changes around 100 times a day. we're trying to ...
We've been thinking about implementing a multi-level caching strategy for our core services to squeeze out every bit of performance. Our current setup...
We're currently scaling our public API to handle about 10,000 requests per second, and rate limiting is a big part of that. We're trying to decide on ...
i recently spent a frustrating week debugging a set of mysteriously slow queries in our system. it turned out to be a classic mistake: the order of co...
we have an analytics dashboard that currently polls an api every 5 seconds for updates. the data is relatively small, but the polling traffic adds up....
we're working on improving our public api rate limiting strategy. currently, we're using a token bucket algorithm at our api gateway, handling about 1...
we're exploring more aggressive cdn edge caching for our product catalog api, which sees around 100k requests per minute. the data changes about 100 t...
At work, we've got this gnarly problem where users are asking for complex 'friends of friends' or 'mutual connections' type queries. In our current SQ...
we rely heavily on read replicas for scaling our database reads, but we've run into persistent issues with replication lag affecting the user experien...
just wanted to share a recent learning that cost us a week of debugging. we had a really slow query on a large table, taking seconds instead of millis...
we have a critical analytics dashboard that currently polls an api every 5 seconds to update charts and metrics. it's for internal use, but the data i...
we have a highly social application, and queries like 'friends of friends' or finding common connections are incredibly slow with our current postgres...
replication lag from read replicas is a constant headache for our user-facing applications. we're seeing anything from 50ms to 200ms of lag, and that'...
i recently spent a whole week debugging a critical performance issue that turned out to be a really subtle problem with a composite index in postgresq...
we have an analytics dashboard that currently polls an api every 5 seconds to update metrics. it's generating a fair amount of load, and the product t...
we're working on improving our public api rate limiting strategy. currently, we have some basic rate limiting at the edge using our api gateway, but t...
