zulhfreelancer
12/12/2016 - 10:23 AM

[Rails performance] - GROUP and JOIN with association's count

[Rails performance] - GROUP and JOIN with association's count

group_and_join_associations_count.md
content_copyfile_download
  • Rendered
  • Source
posts = Post.joins(:comments).group("posts.id").select("posts.*, count(comments.id) as comment_count")

posts.first.comment_count
=> 7