Vertica JDBC load performance

renumetukuru

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

[Deleted User]

Hi, Could you post an example of the code that you're using? (In particular, are you using prepared/batched INSERT statements?) Thanks, Adam

renumetukuru

I tried with prepared statements batch inserts. Its pretty slow. Then used copy through jdbc.. that one also slow..