# 1000 inserts efficiently?

**URL:** <https://www.ruby-forum.com/t/1000-inserts-efficiently/188747>\
**Category:** Rails\
**Created:** [May 17, 2010, 5:59pm UTC](https://www.ruby-forum.com/t/1000-inserts-efficiently/188747 "2010-05-17T17:59:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![saptah](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ccd318/32.png) [@saptah](https://www.ruby-forum.com/u/saptah)\
**Post date:** [May 17, 2010, 5:59pm UTC](https://www.ruby-forum.com/t/1000-inserts-efficiently/188747/1 "2010-05-17T17:59:50Z")

</div>

Hi guys,  
I’m new with RoR, and so far I’m loving it.  
I got a question: ¿How is the most efficient way to insert 1000  
records on the same table?  
I’m trying to insert allot of “items” on the same table, but, right  
now I’m creating an “item” object, with the data, and then call  
item.save.

¿Is there any other way to do this more efficiently?  
P.S: I don’t need validation, etc…

Thanks for all, 🙂

---

<div class="post-metadata">

**Author:** ![saptah](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ccd318/32.png) [@saptah](https://www.ruby-forum.com/u/saptah)\
**Post date:** [May 17, 2010, 6:28pm UTC](https://www.ruby-forum.com/t/1000-inserts-efficiently/188747/2 "2010-05-17T18:28:31Z")

</div>

On May 17, 3:24 pm, saptah [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> 

Write some custom sql to insert rows several at a time. The ar-  
extensions gem does this if my memory is correct

Fred

---

<div class="post-metadata">

**Author:** ![saptah](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ccd318/32.png) [@saptah](https://www.ruby-forum.com/u/saptah)\
**Post date:** [May 18, 2010, 12:11am UTC](https://www.ruby-forum.com/t/1000-inserts-efficiently/188747/3 "2010-05-18T00:11:32Z")

</div>

Hi!  
Thanks for the answer.  
I’ve been reading, and I think this is just want I need.

Thanks again.

On May 17, 6:27 pm, Frederick C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)
