skip to main content
DataDirect Connect XE Drivers : Salesforce Driver : Connection Properties : BulkLoadThreshold
  
BulkLoadThreshold
Purpose
Sets a threshold that, if exceeded, signals the driver to use bulk load for insert, update, delete, or batch operations. If the EnableBulkLoad property is set to true and the number of rows affected by an insert, update, delete, or batch operation exceeds the threshold specified by this property, 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 EnableBulkLoad property 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.
Notes
*If the EnableBulkLoad property is set to false, this 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 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.
Default
4000 (rows)
Data Type
int
See also
Using DataDirect Bulk Load