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.
[ Parent
| on HN ]
There are no comments on this comment yet.