ALL ARTICLES
SHARE

ActiveStorage N+1 Queries: has_one_attached & has_many_attached

Christian Paez
Development
3 min read
ActiveStorage N+1 Queries: has_one_attached & has_many_attached

One of the greatest additions to recent versions of Ruby On Rails is the introduction of Active Storage, which helps us manage file uploads for different storage services and handles Active Record associations and migrations out of the box. A common method from the Active Storage module is has_one_attached, used to establish a one to one mapping between a model and a file (a user’s avatar in our example):

When you install and configure Active Storage, a number of database tables and columns will be created. These tables are polymorphic, so when you need to add ActiveStorage to another model in the future, no database migrations are needed. Thus, we do not need to define the avatar column, Active Storage will handle this under the hood by creating a has_one association to a ActiveStorage::Attachment record and a has_one: through: association to an ActiveStorage::Blob record. There is no need to access these associations directly, we can just call the association name to get a user’s avatar. Here’s an example of accessing the AvtiveStorage relationship:

The Problem: ActiveStorage N+1 Queries

A very common feature to implement in an `index` action would be to display a list of resources and their respective avatar:

Looking for Expert Ruby on Rails Development Services?
See how our experts can help you
SCHEDULE A MEETING

The Solution: Eager Loading

When you call methods from within a loop, you should always be aware of N+1 database queries. An N+1 query is one that hits the database in every iteration of your loop. Doing this can cause very poor performance issues and can even result in request timeouts in some cases. The example above contains an N+1 query. This is because user.avatar is an ActiveStorage has_one relationship. Our model (User), will call its ActiveStorage::Attachment (avatar) relationship on every iteration of the loop in this example code.

So, how do we prevent this N+1 query from occurring? The solution to this is to eager load users’ attachments, just like you would do for any ActiveRecord association. ActiveStorage provides the with_attached_x method to accomplish this out of the box:

It is possible to set up a one-to-many relationship between models and files using the `has_many_attached` macro:

N+1 problems related to ActiveStorage can be handled using the with_attached_attachments helper:

The result is that loading images will take just one query, instead of nested database queries occurring within a loop.

Expert Ruby on Rails Development Services

Flatirons is a top-rated Ruby on Rails service provider.

Schedule a Meeting

Get the CEO's Take

Handpicked tech insights and trends from our CEO.

E-mail

Expert Ruby on Rails Development Services

Flatirons is a top-rated Ruby on Rails service provider.

Schedule a Meeting

Get the CEO's Take

Handpicked tech insights and trends from our CEO.

E-mail
Christian Paez
More ideas.
Proof of Concept Template
Development

Proof of Concept Template: A Step-by-Step Guide

Flatirons

Mar 26, 2025
Objective C and Swift
Development

Objective C vs Swift: Which is Better for iOS App Development?

Flatirons

Mar 25, 2025
Scala and Kotlin
Development

Scala vs Kotlin: Comparing the Functional Programming Giants

Flatirons

Mar 22, 2025
IoT Smart City Solutions
Development

IoT Smart City Solutions: Transforming Urban Living

Flatirons

Mar 17, 2025
Top Minimum Viable Product
Business

Exploring Top Minimum Viable Product Examples

Flatirons

Mar 10, 2025
Narrowband IoT Technology
Development

Explore the Benefits of Narrowband IoT Technology

Flatirons

Mar 02, 2025
Proof of Concept Template
Development

Proof of Concept Template: A Step-by-Step Guide

Flatirons

Mar 26, 2025
Objective C and Swift
Development

Objective C vs Swift: Which is Better for iOS App Development?

Flatirons

Mar 25, 2025
Scala and Kotlin
Development

Scala vs Kotlin: Comparing the Functional Programming Giants

Flatirons

Mar 22, 2025
IoT Smart City Solutions
Development

IoT Smart City Solutions: Transforming Urban Living

Flatirons

Mar 17, 2025
Top Minimum Viable Product
Business

Exploring Top Minimum Viable Product Examples

Flatirons

Mar 10, 2025
Narrowband IoT Technology
Development

Explore the Benefits of Narrowband IoT Technology

Flatirons

Mar 02, 2025
Proof of Concept Template
Development

Proof of Concept Template: A Step-by-Step Guide

Flatirons

Mar 26, 2025
Objective C and Swift
Development

Objective C vs Swift: Which is Better for iOS App Development?

Flatirons

Mar 25, 2025
Scala and Kotlin
Development

Scala vs Kotlin: Comparing the Functional Programming Giants

Flatirons

Mar 22, 2025
IoT Smart City Solutions
Development

IoT Smart City Solutions: Transforming Urban Living

Flatirons

Mar 17, 2025
Top Minimum Viable Product
Business

Exploring Top Minimum Viable Product Examples

Flatirons

Mar 10, 2025
Narrowband IoT Technology
Development

Explore the Benefits of Narrowband IoT Technology

Flatirons

Mar 02, 2025
Proof of Concept Template
Development

Proof of Concept Template: A Step-by-Step Guide

Flatirons

Mar 26, 2025
Objective C and Swift
Development

Objective C vs Swift: Which is Better for iOS App Development?

Flatirons

Mar 25, 2025
Scala and Kotlin
Development

Scala vs Kotlin: Comparing the Functional Programming Giants

Flatirons

Mar 22, 2025
IoT Smart City Solutions
Development

IoT Smart City Solutions: Transforming Urban Living

Flatirons

Mar 17, 2025
Top Minimum Viable Product
Business

Exploring Top Minimum Viable Product Examples

Flatirons

Mar 10, 2025
Narrowband IoT Technology
Development

Explore the Benefits of Narrowband IoT Technology

Flatirons

Mar 02, 2025