The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Maximum read throughput using JDBC

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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.