DEV Community

Cover image for Supercharge Your Rails App: Inserting 1 Million Records in 15s

Supercharge Your Rails App: Inserting 1 Million Records in 15s

Pimp My Ruby on November 01, 2023

In a world where database performance and efficiency are critical factors in application development, the swift import of a large number of records...
Collapse
 
waghanza profile image
Marwan Rabbâa

Great tips, thanks ❤️

Just to notice that 1 billions records will not take 30 seconds to insert (insert_all). It was 3 minutes on my machine

Collapse
 
pimp_my_ruby profile image
Pimp My Ruby

Hi Marwan !

What is your computer ? I may need to specify in my article that I'm running all my benchmark on my M1 Pro so maybe if you have better specs than mine ofc the benchmark will be faster.

I will add this detail to the next articles, thanks for feedback!

Collapse
 
waghanza profile image
Marwan Rabbâa

I don't exactly remember what is my hardware, but it's nearly an M2.

Btw, it is more about saying that we can't just multiply those figures (100K = 3s, 1M = 30s ...).

PS : Sorry it was 1 million, not 1 billion