Specifies the number of rows of data the driver attempts to fetch from the native data source on each request submitted to the server.
Valid Values
0 | x
where:
x
is a positive integer that defines the number of rows.
Behavior
If set to 0, the driver requests that the server return all rows for each request submitted to the server. Block fetching is not used.
If set to x, the driver attempts to fetch up to a maximum of the specified number of rows on each request submitted to the server.
Notes
Native Fetch Size is related to, but different than, Fetch Size. Native Fetch Size specifies the number of rows of raw data that the driver fetches from the native data source, while Fetch Size specifies how many of these rows the driver processes before returning control to the application. Processing the data includes converting native data types to SQL data types used by the application. If Fetch Size is greater than Native Fetch Size, the driver may make multiple round trips to the data source to get the requested number of rows before returning control to the application.
