When you reduce the fetch size of a ResultSet
object, the driver doesn’t copy the entire ResultSet
across the network (from the server to the client). Instead, the driver requests a small number of rows at a time; as the client application moves through the result set, the driver fetches the next batch of rows from the server.
object must be created with a ResultSet
type of TYPE_FORWARD_ONLY
type (which is the default). TYPE_FORWARD_ONLY
result sets can only step forward through the ResultSet