Comment Comment by crazygringo > I realize you can do complicated JOINs, but isn't that almost as bad from a performance perspective?No, JOINs should be orders of magnitude faster.> What are you really supposed to do if you need to, e.g. fetch a list of posts along with the number of comments on each post?You're really supposed to do a JOIN, together with a GROUP BY and a COUNT(). This is elementary SQL. parent crazygringo 1 year ago
No, JOINs should be orders of magnitude faster.
> What are you really supposed to do if you need to, e.g. fetch a list of posts along with the number of comments on each post?
You're really supposed to do a JOIN, together with a GROUP BY and a COUNT(). This is elementary SQL.