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:

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 helps businesses create full-stack Ruby on Rails applications.

Learn more

Expert Ruby on Rails Development Services

Flatirons helps businesses create full-stack Ruby on Rails applications.

Learn more
Christian Paez
More ideas.
Full Stack Developer Resume
Development

Full Stack Developer Resume: Crafting an Impressive Roadmap

Flatirons

Sep 18, 2024
CRM SaaS Solutions
Business

CRM SaaS Solutions: Boost Your Business Efficiency

Flatirons

Sep 16, 2024
Nearshore Software Development Companies
Business

Nearshore Software Development Companies: Top 10 in 2024

Flatirons

Sep 14, 2024
Node.js Interview
Development

Top Essential Node.js Interview Questions in 2024

Flatirons

Sep 12, 2024
What is Pega
Development

What is Pega? Explore the Leading Low-Code Platform

Flatirons

Sep 12, 2024
Bluetooth 5.0 vs. 5.3
Development

Bluetooth 5.0 vs. 5.3: All You Need To Know

Flatirons

Sep 09, 2024
Full Stack Developer Resume
Development

Full Stack Developer Resume: Crafting an Impressive Roadmap

Flatirons

Sep 18, 2024
CRM SaaS Solutions
Business

CRM SaaS Solutions: Boost Your Business Efficiency

Flatirons

Sep 16, 2024
Nearshore Software Development Companies
Business

Nearshore Software Development Companies: Top 10 in 2024

Flatirons

Sep 14, 2024
Node.js Interview
Development

Top Essential Node.js Interview Questions in 2024

Flatirons

Sep 12, 2024
What is Pega
Development

What is Pega? Explore the Leading Low-Code Platform

Flatirons

Sep 12, 2024
Bluetooth 5.0 vs. 5.3
Development

Bluetooth 5.0 vs. 5.3: All You Need To Know

Flatirons

Sep 09, 2024
Full Stack Developer Resume
Development

Full Stack Developer Resume: Crafting an Impressive Roadmap

Flatirons

Sep 18, 2024
CRM SaaS Solutions
Business

CRM SaaS Solutions: Boost Your Business Efficiency

Flatirons

Sep 16, 2024
Nearshore Software Development Companies
Business

Nearshore Software Development Companies: Top 10 in 2024

Flatirons

Sep 14, 2024
Node.js Interview
Development

Top Essential Node.js Interview Questions in 2024

Flatirons

Sep 12, 2024
What is Pega
Development

What is Pega? Explore the Leading Low-Code Platform

Flatirons

Sep 12, 2024
Bluetooth 5.0 vs. 5.3
Development

Bluetooth 5.0 vs. 5.3: All You Need To Know

Flatirons

Sep 09, 2024
Full Stack Developer Resume
Development

Full Stack Developer Resume: Crafting an Impressive Roadmap

Flatirons

Sep 18, 2024
CRM SaaS Solutions
Business

CRM SaaS Solutions: Boost Your Business Efficiency

Flatirons

Sep 16, 2024
Nearshore Software Development Companies
Business

Nearshore Software Development Companies: Top 10 in 2024

Flatirons

Sep 14, 2024
Node.js Interview
Development

Top Essential Node.js Interview Questions in 2024

Flatirons

Sep 12, 2024
What is Pega
Development

What is Pega? Explore the Leading Low-Code Platform

Flatirons

Sep 12, 2024
Bluetooth 5.0 vs. 5.3
Development

Bluetooth 5.0 vs. 5.3: All You Need To Know

Flatirons

Sep 09, 2024