Purpose

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.

Data Source Method

setBulkLoadThreshold

Default

4000 (rows)

Data Type

int

See also