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.
BulkTopThreshold
Purpose:
Specifies a threshold for determining whether bulk operations are used to process qualifying Select queries that include a Top n clause.
Performance Impact:
Due to the overhead associated with bulk operations, processing queries with a Top n clause are sometimes more efficient using a standard query when fetching only a few rows.
Recommended Settings:
Tune this setting for your environment. Specify the maximum amount of rows you want to fetch before bulk load operations are enabled.
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 1000 rows typically provides the maximum throughput. However, for interactive applications, you can reduce response time by setting WSFetchSize at a lower value.
