Maximum read throughput using JDBC

Luc_Lecocq

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