Maximum read throughput using JDBC

Luc_LecocqLuc_Lecocq
in General Discussion

Hi,

 

We have a java app that reads data from a table on a 4 nodes vertica cluster, using the JDBC vertica driver with the native load balancer enabled.

Our problem is that we can't get more than 9MB/sec per node

When using a VSQL client on the same system where our app runs, and dumping the same table to a local file, we get 30 MB/sec.

I even tried to start 6 simultaneous VSQL clients from 6 different systems, we get 6 times 27.5 MB/s, so obviously there is no problem with the Lan (10 Gb)

 

Anyone having some results or experience with the JDBC driver ?

 

Thanks in advance for helping,

Regards

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