skip to main content
Connection Option Descriptions : Fetch Size
  

Try DataDirect Drivers Now

Fetch Size

Attribute

FetchSize (FS)

Purpose

Specifies the number of rows that the driver processes before returning data to the application. Smaller fetch sizes can improve the initial response time of the query. Larger fetch sizes improve overall fetch times at the cost of additional memory.
FetchSize is related to, but different than, WSFetchSize. WSFetchSize specifies the number of rows of raw data that the driver fetches from the remote data source, while FetchSize specifies how many of these raw data rows the driver processes before returning data to the application. Processing the data includes converting from the remote data source data type to the driver SQL data type used by the application. If FetchSize is greater than WSFetchSize, the driver makes multiple round trips to the data source to get the requested number of rows before returning control to the application.

Valid Values

0 | x
where:
x
is a positive integer.

Behavior

If set to 0, the driver fetches and processes all of the rows of the result before returning control to the application.
If set to x, the driver fetches and processes the specified number of rows before returning data to the application.

Notes

*This option can affect performance.

Default

100

GUI Tab

Advanced tab

See also

WSFetchSize
This connection option can affect performance. See Performance Considerations for details.