I was facing a problem where I wanted to insert millions of records into the database, which needed to be imported from the file.
So, I did some research around this, and I would like to share with you what I found which helped me improve the insert records throughput by nearly 100 times.
We got a few requests for some guidance on how to optimize the RavenDB insert rate. Our current benchmark is standing at 135,000 inserts/sec on a sustained basis on a machine that costs less than $1,000. However, some users tried to write their own benchmarks and got far less (about 50,000 writes/sec). Therefore, in this post, I’m going to do a bunch of things and see if I can make RavenDB write really fast.
I’m going to be writing this post as I’m building the benchmark and testing things out. So, you’ll get a stream of consciousness. Hopefully it will make sense.
