skip to main content
Getting Started : Advanced Features : Using DataDirect Bulk Load : Using Bulk Load for Batch Inserts : Using Bulk Load for Single Inserts/Updates/Deletes (Salesforce Driver)
  
Using Bulk Load for Single Inserts/Updates/Deletes (Salesforce Driver)
When the EnableBulkLoad property is set to true, the Salesforce driver uses the Salesforce Bulk API for single Insert, Update, and Delete statements if the number of rows affected by the operation exceeds the threshold set by the BulkLoadThreshold connection property. For example, if you set the EnableBulkLoad property to true and the BulkLoadThreshold property to 2000, executing the following statement would use the Bulk API if the number of rows returned by SELECT rowid, sys_name FROM account is more than 2000 rows.
INSERT INTO tmpAccounts(accountId, accountName)
SELECT rowid, sys_name FROM account