Part 4: The Connect XE Drivers : The Salesforce Driver : Using DataDirect Bulk Load With the Salesforce Driver : Using Bulk Load for Single Inserts/Updates/Deletes

Using Bulk Load for Single Inserts/Updates/Deletes
You can configure the driver to use the bulk load protocol when it encounters a request to execute a single Insert, Update, or Delete statement that affects many rows. When the EnableBulkLoad connection option 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 option.
For example, if you set the EnableBulkLoad connection option to true and the BulkLoadThreshold connection option 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

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.