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..


  • Options
    Hi, Could you post an example of the code that you're using? (In particular, are you using prepared/batched INSERT statements?) Thanks, Adam
  • Options
    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
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file