BulkLoadThreshold
- Last Updated: April 18, 2018
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
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.
Default
4000 (rows)
Data Type
int