Hacker News new | ask | show | jobs
by spimmy 4034 days ago
Keep in mind that we're a platform, not a website, and we have very little control over things like schemas, slow queries, inefficient looping requests that our developers send us. We can't optimize 500 thousand apps' queries for them.

So for example if an app does something bad like performing a full table scan on every request against a 300 million collection, so every request to that backend is timing out at 30 seconds, and there are thousands of them per second, well -- pretty soon your fixed pool will be full of requests timing out to that backend.

1 comments

This is totally a great explanation, thanks! This sort of thing is why I hate working on platforms (but also why it's so in-demand).