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
},