Not necessarily. If you have an index into the posts and you want all the comments for a given article you can find the post quickly and the comments are just o

Not necessarily. If you have an index into the posts and you want all the comments for a given article you can find the post quickly and the comments are just one hop away from that. Beyond that it's just like SQL (order by, limit, etc.).