# Multiple Inserts

**URL:** <https://www.ruby-forum.com/t/multiple-inserts/108479>\
**Category:** Rails\
**Created:** [July 3, 2007, 11:37pm UTC](https://www.ruby-forum.com/t/multiple-inserts/108479 "2007-07-03T23:37:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mwalsh](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/91b2a8/32.png) [@mwalsh](https://www.ruby-forum.com/u/mwalsh)\
**Post date:** [July 3, 2007, 11:37pm UTC](https://www.ruby-forum.com/t/multiple-inserts/108479/1 "2007-07-03T23:37:42Z")

</div>

Hello,

I am trying to optimize my Rails code for database inserts. I often  
have to insert/update several thousand records after web crawls. Once  
I have all the data to insert/update, what are some good ways to  
optimize this? I’ve looked into doing multiple inserts using object-  
level transactions. However, the Rails API states that this  
functionality is deprecated ([http://api.rubyonrails.org/classes/](http://api.rubyonrails.org/classes/)  
ActiveRecord/Transactions/ClassMethods.html#M000681). What is the  
preferred method? Thanks!