#2 diskmode caching of resultsets

[Vivake Gupta]

Since MySQL doesn't have server-side cursors, when you
issue a query that returns a very large amount of
data, all of this data is dumped to the JDBC driver at
once. The JVM must be given a large max heap size to
be able to hold all of this ResultSet in memory while
you next() through it.

It would be nice if there were a cacheMode=disk option
(a la twz) whereby the ResultSet would be cached on
disk rather than in memory. Granted, this would slow
down access to the data, but in situations where
memory is constrained, would be an acceptable
compromise.

Thanks,
Vivake (vivake at nano.com)