I’ve tried to insert data using batch insert (using the piece of code in the doc) and figured out it was very slow (10th of insertions per seconds). I have not taken the time to investigate further but that’s probably an issue, comparing with SQLite, inserting ~20K rows where pretty much instant in SQLite.
I’ve tried to insert data using batch insert (using the piece of code in the doc) and figured out it was very slow (10th of insertions per seconds). I have not taken the time to investigate further but that’s probably an issue, comparing with SQLite, inserting ~20K rows where pretty much instant in SQLite.