It's not clear in the code how you're batching the writes. Could the performance improvement be mostly explained by batches?
Looks like he’s doing 1M INSERTs per transaction.
In his 2nd example he’s doing the same thing, except he first sorts the data for each of those 1M INSERTs, leading to a 2-3x speedup.
alt Hacker News
Looks like he’s doing 1M INSERTs per transaction.
In his 2nd example he’s doing the same thing, except he first sorts the data for each of those 1M INSERTs, leading to a 2-3x speedup.