News for hackers. Stuff that matters.
Re:Ask HN: What do I need to learn how to write a scalable app? by LarryMade2 on Wednesday June 03, 2020 @10:45AM (#23403882)
Optimise your queries as well, complex queries with multiple many-to-many joins will add up quick to tons of rows to filter. Look at separating queries; to keep the overall in a single query, the db may have to churn through tens of thousands of rows. Where if you do a first select than a second based on the result of the first, you can bring it down to just hundreds or tens - with a quicker response than just one query.

There are no comments on this comment yet.