Attribute

WSFetchSize (WSFS)

Purpose

Specifies the number of rows of data the driver attempts to fetch for each ODBC call.

Valid Values

0 | x

where:

x
is a positive integer from 1 to the maximum page size allowed that defines a number of rows.

Behavior

If set to 0, the driver uses the maximum page size for the Oracle Service Cloud database to which it is connecting (Operational or Report) for sites whose version is August 2014 or later. When connecting to sites whose version is prior to August 2014, the driver attempts to fetch up to a maximum of 10,000 rows. This value typically provides the maximum throughput.

If set to x, the driver attempts to fetch up to a maximum of the specified number of rows. Setting the value lower than 10,000 can reduce the response time for returning the initial data. Consider using a smaller WSFetch Size for interactive applications only.

If the value specified is greater than the value allowed by the server, the driver returns a warning that the setting exceeds the maximum value and uses the maximum value permitted. For servers prior to version August 2014, the maximum is 10,000 rows. For versions August 2014 and later, the maximum is server dependent.

Notes

  • This option can affect performance.

Default

0 (up to a maximum of 10,000 rows)

GUI Tab

Web Service tab

See also

Fetch Size

WSTimeout

This connection option can affect performance. See Performance considerations for details.