Hi all !
This is not at all the right forum.
Anyway it should be SQL feature "Fetch Size" through JDBC's "ResultSet.setFetchSize(rows)".
Please consult "Best practices to improve performance in JDBC" at :
http://www.precisejava.com/javaperf/j2ee/JDBC.htm#JDBC119 Optimization with ResultSet
...........................
1. Do batch retrieval using ResultSet
ResultSet interface also provides batch retrieval facility like Statement as mentioned above. It overrides the Statement behaviour.
Initially find the default size by using
ResultSet.getFetchSize(); and then set the size as per requirement
ResultSet.setFetchSize(50);
This feature significantly improves performance when you are dealing with retrieval of large number of rows like search functionality.
Best regards.
Eric LEMAITRE
CNAM IT Engineer, MS/CS (RHCE, RHCX, SCJA, SCJP, SCJD, SCWCD, SCBCD, SCEA, Net+)
Free Online Tutorials: http://www.free-tutorials-online.net/