Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica JDBC load performance

Hi Team, I am trying to load the data using jdbc program. am using copy statement. To laod 10k rows, its taking 3 min and to load 100k rows its taking 16-120 min. anything wrong.. same in mysql we are able to load in 2-3 min..

Comments

  • Hi, Could you post an example of the code that you're using? (In particular, are you using prepared/batched INSERT statements?) Thanks, Adam
  • I tried with prepared statements batch inserts. Its pretty slow. Then used copy through jdbc.. that one also slow..

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.