Re:Inserting a billion rows in SQLite under a minute
by wuxb on Sunday July 18, 2021 @09:05PM
(#27878198)
Just tried to insert 100M KV pairs of the same data format in a KV store. It takes about 26s on a Xeon Silver 4210, including fully writing down the data to the filesystem/SSD.
The source code can be found here: https://github.com/wuxb45/remixdb/blob/master/i100m.c