Purpose

Specifies the number of rows of data the driver attempts to fetch for each JDBC call when paging is enabled for an endpoint.

Note: To enable paging, specify paging parameters for an endpoint in the Model file. See "Creating a Model file" for details.

Valid Values

0 | x

where:

x

is a positive integer that defines a number of rows. The maximum is defined by the setting of the maximumPageSize property in the Model file.

Behavior

If set to 0, the driver attempts to fetch up to the maximum number of 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 the maximum can reduce the response time for returning the initial data. Consider using a smaller value for interactive applications only.

Notes

WSFetchSize and 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.

Data Source Methods

public Integer getWSFetchSize()

public void setWSFetchSize(Integer)

Default Value

2000

Data Type

Integer