Specifies a number of rows that, if exceeded, signals the driver to use the Salesforce Bulk API for select operations. For this behavior to take effect, the EnableBulkFetch property must be set to true.
Valid Values
0 | x
where:
x
is a positive integer that represents a number of rows.
Behavior
If set to 0, the driver uses the Salesforce Bulk API for all select operations.
If set to x, the driver uses the Salesforce Bulk API for select operations when the value of x is exceeded.
Notes
If the EnableBulkFetch property is set to false, the BulkFetchThreshold property is ignored.
The EnablePKChunking connection property can be used to break bulk fetch operations into smaller, more manageable batches for improved performance.
Do not set the BulkFetchThreshold property to a value greater than the Web service call limit set by the StmtCallLimit property. If the value set for BulkFetchThreshold is greater than the value of StmtCallLimit, the driver would not use the Salesforce Bulk API for fetch operations because the Web service call limit would be reached before the driver reached the threshold to use the Salesforce Bulk API.
If the EnableBulkFetch property is set to false, the BulkFetchThreshold property is ignored.