crate-pdo icon indicating copy to clipboard operation
crate-pdo copied to clipboard

Improving efficiency with bulk inserts

Open amotl opened this issue 2 years ago • 0 comments

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

amotl avatar Apr 01 '23 16:04 amotl