How can resultset records be restricted to certain rows?

Govind Seshadri

The easy answer is "Use a JDBC 2.0 compliant driver".

With a 2.0 driver, you can use the setFetchSize() method within a Statement or a ResultSet object.

For example,

 Statement stmt = con.createStatement();
 ResultSet rs = stmt.executeQuery("select * from customers");

will change the default fetch size to 400.

You can also control the direction in which the rows are processed. For instance:

will process the rows from bottom up.

The driver manager usually defaults to the most efficient fetch size...so you may try experimenting with different value for optimal performance.