Maximum read throughput using JDBC



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,


Leave a Comment

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