crate-pdo
crate-pdo copied to clipboard
Improving efficiency with bulk inserts
Hi again,
as a followup to GH-138, users of this library also reported flaws on the aspect of running bulk data imports.
We batch together multiple messages, and then translate them into bulk insert statements. Are there any limits we should bear in mind, for doing bulk inserts?
After analyzing a wire dump of database conversations with CrateDB [^1], it looks like this driver is not using
bulk_args[^2] yet.
With kind regards, Andreas.
/cc @hlcianfagna, @hammerhead
[^1]: sudo ngrep -d lo0 -Wbyline port 4200
[^2]: CrateDB HTTP bulk operations interface