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 Enable Bulk Fetch option must be set to 1 (enabled).
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 Enable Bulk Fetch option is set to 0 (disabled), the Bulk Fetch Threshold option is ignored.
The Enable Primary Key Chunking connection option can be used to break bulk fetch operations into smaller, more manageable batches for improved performance.