DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

Pierre Jambet
Pierre Jambet

Posted on • Updated on • Originally published at blog.pjam.me

Active Record caches generated queries for find_by queries

tl;dr; Active Record caches generated queries, when using find_by and find. This is a different type of cache, unrelated to QueryCache and prepared statements.

What exactly does Active Record cache, and when?

When you call Post.find(1) or Post.find_by(id: 1), Active Record will cache the result of build_arel in a StatementCache instance. The build_arel method is the one that generates the actual underlying query, in this case, SELECT * FROM posts WHERE id = ?.

Why does it actually matter?

This is a small internal optimization that should be invisible in most cases. The generated queries are parameterized, so once they are cached, they can be reused regardless of the arguments. It should speed things up and all is well.

I had an issue when hooking into Active Record’s internals, using a custom module included into ActiveRecord::Relation:

module M
  def build_arel(aliases=nil)
    super.tap do |arel|
      # look into the generated query
    end
  end
end

ActiveSupport.on_load :active_record do
  ActiveRecord::Relation.include M
end
Enter fullscreen mode Exit fullscreen mode

I was expecting my custom code inside #tap to always be executed, but since Active Record caches the result of build_arel, the first call would go through build_arel and subsequent calls to find would use the cached result and never hit the #tap method.

A quick workaround I found was to add arel.model.intialize_find_by_cache if Rails.env.test? at the end of my #tap block, to make sure the cache would get reset and therefore nothing would actually end up cached. In my case, this was a test only thing, and resetting the cache in this context was not an issue.

Final words

I used to be scared of digging into Rails’ code, afraid it would be β€œtoo complicated”. But it’s actually not that bad! I fully recommend checking it out, if you don’t know where to start, let me recommend the find method.

Links:

Top comments (0)

We are hiring! Do you want to be our Senior Platform Engineer? Are you capable of chipping in across sysadmin, ops, and site reliability work, while supporting the open source stack that runs DEV and other communities?

This role might just be for you!

Apply now