Options

Vertica JDBC load performance

renumetukururenumetukuru
in General Discussion
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

  • Options
    [Deleted User][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
  • Options
    renumetukururenumetukuru
    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...