Fix N+1 Queries Without Eager Loading Using SQL Subquery

Fetching the latest record from a has_many association can be a performance bottleneck in Rails. This post explores using SQL subqueries as an efficient alternative to eager loading. By embedding a subquery in the SELECT clause, developers can retrieve only the needed data without loading all associated records. This approach reduces query count, memory usage, and page load times. The article provides code examples and performance metrics to demonstrate the benefits of using subqueries for this task.