Is it better to use one over the other? Will ODBC allow me to pull data more quickly over the network? Right now I'm using JDBC and the fetch size is set to 10,000 and batch is 100 but the network utilization is about 4% of total bandwidth. It looks like this is because of the fetch size? If I switch to ODBC will I utilize more of the bandwidth available then?
I have a front end application (Tibco Spotfire) which connects to Oracle Exadata via JDBC right now. The network utilization on the Exadata and application size is very low right now but I do pull a lot of data to the application and it takes quite sometime (20-30min) to grab all the rows AFTER the query is done processing. Trying to see if I can speed up the data transfer from Exadata to the application.