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,