Specifies the number of rows of data the driver attempts to fetch for each JDBC call.
Valid Values
x
where:
x
is a positive integer from 100 to 4000 that defines a number of rows.
Behavior
If set to x, the driver attempts to fetch up to a maximum of the specified number of rows. Setting the value lower than the maximum can reduce the response time for returning the initial data; therefore, consider specifying smaller values for interactive applications.
Notes
Web Service Fetch Size and Fetch Size (FetchSize) can be used to adjust the trade-off between throughput and response time. Smaller fetch sizes can improve the initial response time of the query. Larger fetch sizes can improve overall response times at the cost of additional memory.