Retrieving of large ResultSets

Hi,

I need to retrieve several large (>300 k rows) results from 100 tables.
Each of these tables has 101 columns.

Does any of you have an idea about the best strategy ?

I am currently planning to test the two following ones.

1) Retrieving by block (500 rows at a time for instance)
2) Line by line with
stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
              java.sql.ResultSet.CONCUR_READ_ONLY);
stmt.setFetchSize(Integer.MIN_VALUE);

As indicated in the documentation.

Any thought ?

Regards
-- 
Nicolas Palix

-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]