Ingestions speed with JDBC


#1

Hi
Couple years ago I had done one POC with crate and then I was testing ingestion speed. Use of Copy from command was suggested over JDBC insert.

With latest versions is that still true ?
Or JDBC inserts are now improved to insert with same speed as copy from command ?


#2

Thanks for reaching out to us. In general, COPY from command is many times faster than inserting multi-row values using a traditional jdbc insert. Copy From gets data from file system into a table efficiently, mainly it depends on your setup if would to look into the possible ways to insert data to crate, please refer this doc - https://crate.io/docs/crate/guide/en/latest/performance/inserts/methods.html

We would like to let you know that we have been putting lots of performance improvements in the recent versions of overall CrateDB.

Also, here are a few easy steps incase you would like to get hands on and do some performance testing on your end, refer - https://crate.io/docs/crate/guide/en/latest/performance/inserts/testing.html