Rails Active Record - Save multiple objects at once

Question

I took a look a this question and didn't found any answer that worked for me.

I have, for example a Project model, which has_many tasks. I would like to create, from an array of attributes, many tasks for some project. So, in my project model, I would have a method like this (simplified example):

def create_tasks(tasks)
   tasks.map{|t| Task.create(project: self, name: t.name)}
end

The problem is, for each task, it will make a hit on my db, and for a large number of records that wouldn't be desirable. How could I do that so ActiveRecord will make only one call to my database? Thanks in advance!

Mikhail Katrin · Accepted Answer · 2018-07-04 15:03:02Z

5

Each call for insertion into database will be done separately (in different transactions). But you could decrease a total delay wrapping all creations in a single transaction.

Task.transaction do
    tasks.each{ |task| Task.create(...) }
end

In this case all your creations will be wrapped in one atomic db transaction.

Take a look at transaction documentation.

Also you could try accepts_nested_attributes_for.

Nested attributes allow you to save attributes on associated records through the parent.

Hope it helps.

edited Jul 4, 2018 at 15:03

answered Jul 4, 2018 at 14:55

Mikhail Katrin

2,4041 gold badge12 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ronan Lopes Over a year ago

Thanks, I'm gonna do that. Also, do you think that would be good to use threads for doing each insert?

Ronan Lopes Over a year ago

also, there's a typo on "create"

Mikhail Katrin Over a year ago

If you're talking about Thread, they are for concurrent (not parallel) programming. You won't get any profits of using it.

Collectives™ on Stack Overflow

Rails Active Record - Save multiple objects at once

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related