Chris Bicnal wrote:How about adding an index (or indexes) to the data you're reading - this would improve performance!
Rohan Dhapodkar wrote: properly setting fetchSize on JDBC Statement, improves throughput considerably (about 10x).
Pat Farrell wrote:So my tests with MySql show that there is no advantage, none at all, with settting the fetch size.
Paul Clapham wrote:However would it be fair to guess that your tests were done in an environment with MySQL running locally? And that the results might have been different if the server was running elsewhere on the network?