Attribute

FetchSize (FS)

Purpose

Specifies the maximum number of rows the driver returns in a network round trip when Use Declare Fetch connection option is set to 1 (UseDeclareFetch=1).

Valid Values

x

where

x
is a positive integer between 1 and 2,147,483,647 that indicates the maximum number of rows the driver returns in a network round trip. If no value or a value outside this range is specified, the driver sets Fetch Size to 50,000.

Notes

  • Fetch and A7 are the aliases for the Fetch Size connection option.
  • Fetch Size 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.

Default

50000

GUI Tab

Advanced tab

Use Declare Fetch