Re: ResultSet fetch in Batches

[Mark Matthews]

John Doe,

MySQL doesn't work that way. The default mode of result set retrieval is "firehose", i.e. the client doesn't make a round trip for each row, they just "show up" from the server.

If the issue you're running into is a memory utilization issue, I suggest deciding whether you actually need all of the result set at the client for doing the required work, or if you can use "streaming" result sets, which process a row at a time, still without "round trips".

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html