Bulk insert 2 billion records


#1

Migrating a DB (about 2 billion records, 50 simultaneous theads) to FDB.
The bottleneck is the SSD.
I would like to speed up the migration process.

E.g.: PRAGMA synchronous = off would make sqlite a magnitude faster.
Is there a knob to weaken the durability?

fdbcli --exec status says:
Performance limited by process: Storage server performance (storage queue).
and the JSON status:
"durability_lag" : {
"seconds" : 318.71800000000002,
"versions" : 318717519
},


#2

Answered here: