title: ResultSet behavior with MySQL database, does it store all rows in memory?
body: <p>When returning results from a select query, does the ResultSet store all of the rows in memory? Or does it only fetch a limited amount of rows?  Does it differ database to database?  What's the behavior for MYSQL?</p>