The connection properties described in this section directly affect the performance of your driver. To tune for performance, configure your driver according to the recommended settings and your environment.
WSFetchSize
Purpose:
Specifies the maximum number of rows of data the driver can attempt to fetch for each call.
Performance Impact:
WSFetchSize can be used to adjust the trade-off between throughput and response time. In general, setting larger values for WSFetchSize will improve throughput, but at the expense of slower response time.
Recommended Settings:
The WSFetchSize connection property allows you to specify the maximum number of rows allowed for a fetch on each call to the web service. The default value of 100 rows typically provides the maximum throughput. However, for interactive applications, you can reduce response time by setting WSFetchSize at a lower value.
