Here's a branch that speeds it up by batching the barcode inserts into a single DB call.
Note I also tried this:
osb.setPragma({enableBundledMode: true});
It had no noticeable affect on the speed, so I disabled it.
On my test system, I loaded 611k rows in about 50 seconds. In prior tests I gave up after about 10 minutes.
The code contains extra debug logs we might want to remove for merging.
Here's a branch that speeds it up by batching the barcode inserts into a single DB call.
Note I also tried this:
osb.setPragma( {enableBundledM ode: true});
It had no noticeable affect on the speed, so I disabled it.
On my test system, I loaded 611k rows in about 50 seconds. In prior tests I gave up after about 10 minutes.
The code contains extra debug logs we might want to remove for merging.