Skip to content

Instantly share code, notes, and snippets.

@deepakmahakale

deepakmahakale/N-plus-1-fixed-with-scope.rb

Created March 22, 2019 07:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save deepakmahakale/7410cc75a5d08244b076ffdcd658cd3b to your computer and use it in GitHub Desktop.
Save deepakmahakale/7410cc75a5d08244b076ffdcd658cd3b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
N-plus-1-fixed-with-scope.rb
User.includes(:published_posts).map do |user|
[user.name, user.published_posts.map(&:title).join(', ')]
end
User Load (0.3ms) SELECT "users".* FROM "users"
Post Load (0.3ms) SELECT "posts".* FROM "posts" WHERE (published = 't') AND "posts"."user_id" IN (1, 2, 3)
#=> [["Jack", "post-1, post-2"], ["Adam", "post-3, post-3"], ["John", "post-5, post-6"]]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment