News for hackers. Stuff that matters.
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

    $ make i100m.out libremixdb.so
    $ numactl -N 0 ./i100m.out
    insert time without sync: 24.865s, with sync: 25.801s

There are no comments on this comment yet.