Determines when the driver uses bulk load for inserts, updates, or deletes. If the Enable Bulk Load option is set to 1 (enabled) and the number of rows affected by an insert, update, delete, or batch operation exceeds the threshold specified by this option, the driver uses the Salesforce Bulk API to perform the operation.
Valid Values
0 | x
where:
x
is a positive integer that represents a threshold (number of rows).
Behavior
If set to 0, the driver always uses bulk load to execute inserts, updates, or deletes.
If set to x, the driver only uses bulk load if the Enable Bulk Load option is set to a value of 1 (enabled) and the number of rows to be updated by an inserts, updates, or deletes exceeds the threshold. If the operation times out, the driver returns an error.
Notes
If the Enable Bulk Load option is set to 0 (disabled), this option is ignored.
Do not set the Bulk Load Threshold option to a value greater than the Web service call limit set by the Statement Call Limit option. If the value set for Bulk Load Threshold is greater than the value of Statement Call Limit, the driver would never use the Salesforce Bulk API because the Web service call limit is reached before the driver reaches the threshold to switch to the Salesforce Bulk API.
If the Enable Bulk Load option is set to 0 (disabled), this option is ignored.