Determines when the driver uses bulk load for insert, update, delete, or batch operations. If the Enable Bulk Load option is set to True 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 insert, update, delete, or batch operations.
If set to x, the driver only uses bulk load if the Enable Bulk Load option is set to a value of True and the number of rows to be updated by an insert, update, delete, or batch operation exceeds the threshold. If the operation times out, the driver returns an error.
Notes
If the Enable Bulk Load option is set to false, 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 false, this option is ignored.