Specifies a number of rows that, if exceeded, signals the driver to use the Salesforce Bulk API for inserts, updates, and deletes. For this behavior to take effect, the EnableBulkLoad 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 inserts, updates, and deletes.
If set to x, the driver uses the Salesforce Bulk API to execute the insert, update, or delete operation when the value of x is exceeded.
Notes
If the EnableBulkLoad property is set to false, the BulkLoadThreshold property is ignored.
Do not set the BulkLoadThreshold property to a value greater than the Web service call limit set by the StmtCallLimit property. If the value set for BulkLoadThreshold is greater than the value of StmtCallLimit, the driver would not use the Salesforce Bulk API because the Web service call limit would be reached before the driver reached the threshold to use the Salesforce Bulk API.
If the EnableBulkLoad property is set to false, the BulkLoadThreshold property is ignored.