Forum: Ruby on Rails inserting many records into a database

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Sandworth M. (Guest)
on 2008-12-08 14:16
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
Craig D. (Guest)
on 2008-12-08 16:17
(Received via mailing list)
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 D..

Regards,
Craig
Sandworth M. (Guest)
on 2008-12-10 03:12
Thanks a lot! That looks really useful.
This topic is locked and can not be replied to.