Specifies the number of rows of data the driver attempts to fetch for each JDBC call when paging is enabled for an endpoint.
Valid Values
0 | x
where:
x
is a positive integer that defines a number of rows.
Behavior
If set to 0, the driver attempts to fetch up to a maximum of 1000 rows. This value typically provides the maximum throughput.
If set to x, the driver attempts to fetch up to the 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 WSFetch size 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.
The values specified for the WSFetchSize and FetchSize properties provide only a suggestion as to the number of rows to be processed. Jira will not exceed these values, but it will adjust page sizes to balance throughput amongst all its users. This behavior can result in different page sizes for successive queries.
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.