Multiple SQL statements for a single array of hash insert

Question

I am doing something like this to insert multiple records at the same time in my rails app.

VoteRecord.create(
  [
    { :prospect_id => prospect.id, :state => "OH", :election_type => "GE" },
    { :prospect_id => prospect.id, :state => "OH", :election_type => "PR" }
    ...
   ]  
)

When I check the log i see that the insert query is fired multiple times by sql. Is it possible to do this in a single query?

Amar · Accepted Answer · 2012-09-13 08:52:41Z

2

You can try active record import for bulk import,checkout wiki and example page.

answered Sep 13, 2012 at 8:52

Amar

6,9524 gold badges27 silver badges23 bronze badges

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

Comments

EfratBlaier · Accepted Answer · 2012-09-13 09:03:47Z

0

I haven't used it myself, but you should check out the activerecord-import project (for Rails 3) github More on this can be found here: wiki

answered Sep 13, 2012 at 9:03

EfratBlaier

5592 silver badges6 bronze badges

1 Comment

jdoe Over a year ago

Duplicate! See Amar's answer.

Collectives™ on Stack Overflow

Multiple SQL statements for a single array of hash insert

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related