ruby_joins_to_avoid_n+1.rb

#Author: Shubham Mishra

# Without joins
@users = User.all
@users.each do |user|
  puts "User: #{user.name}"
  puts "Posts: #{user.posts.count}"
  puts "Comments: #{user.comments.count}"
end

# With joins
@users = User.joins(:posts, :comments).select("users.*, count(distinct posts.id) as post_count, count(distinct comments.id) as comment_count").group("users.id")
@users.each do |user|
  puts "User: #{user.name}"
  puts "Posts: #{user.post_count}"
  puts "Comments: #{user.comment_count}"
end