Benito Serna Tips and tools for Ruby on Rails developers

Tool to run the fixes for the latest-comment n+1 queries problem

November 10, 2020

Do you have to fetch the latest “x” of each record?

One example of this problem is trying to get the latest comment on a list of posts, but there are others, like the last review in a list of products, or the cheapest price, or the latest payment for each costumer, etc…

I want to share with you the code I used in the post 5 ways to fix the latest-comment n+1 problem.

You can use it to run the examples and play with the code and seed values, to pick the right solution for you current case.

You can see the code on github at bhserna/latest_comment_n-1_examples

Related articles

No more… “Why active record is ignoring my includes?”

Get for free the first part of the ebook Fix n+1 queries on Rails that will help you:

  • Explain what is an n+1 queries problem
  • Identify when ActiveRecord will execute a query
  • Solve the latest comment example
  • Detect n+1 queries by watching the logs
  • Learn the tools to detect n+1 queries
Get the first part of the ebook for free