Saving those extra queries

In Rails apps, eager loading and the ActiveRecord relation chains are good ways for keeping in check the number of queries we fire. But its also easy to lose their benefits. Here are some examples -

The count

The count method always introduces a new query. If the query has already been fired, this one is unnecessary. Its not N+1, but still wasteful. The solution is to use size instead of count.

posts = Post.where(user_id:
posts.to_a   # Query fired
posts.count  # Query fired
posts.size   # No query fired

posts = Post.where(user_id:
posts.each do |post|           # Query fired   
post.comments.count # New query
post.comments.size  # No new query

The pluck

Note: This is fixed in Rails-5

pluck doesn’t make use of an existing relation chain - it always fires a new query.

posts = Post.where(user_id:
posts.to_a           # Query fired
posts.pluck(:title)  # Another query fired   # No new query

Fix: Using map instead of pluck

The parent reference

The following code will make an N+1

Within a Comment model:

belongs_to :post
def post_title

And then:

posts = Post.where(user_id:

The example looks a little absurd because we could have done instead of the second line. But this is just an (over simplified) example - such a thing can occur when method call sequence more complicated. Its ever hard to notice such a thing without a tool.

The fix - the following slightly ridiculous bit:

posts = Post.where(user_id: => [:post])

That’s it. If you have any more ideas, please share in comments.

Published: 13 May 2016