inserting many records into a database

rubyonrails-talk
1

Hi,

I want to insert many records into a database. If I do them one-by-one, it takes a long time. Does Rails have a method to optimize this -- creating a single SQL command for many records, maybe? The entries I want to enter are all children to a single parent. Creating an array children_array of the child objects is fast; it's when I do

children_array.each do |child|   children<<child end

that it takes a long time. (Here children is the name of the table that has child objects.)

Thanks! - Farmer

2

You might be able to use ar-extensions [http://www.continuousthinking.com/tags/arext] [http://github.com/zdennis/ar-extensions/tree/master] from my friend and colleague, Zach Dennis.

Regards, Craig

3

Thanks a lot! That looks really useful.