The driver uses Salesforce Bulk API for executing selects, inserts, deletes, and updates based on the values of the Enable Bulk Load and Enable Bulk Fetch connection options.
For information on other connection options that influence the behavior of Salesforce Bulk API, see "Summary of Options for Using Bulk API with SQL Statements."
Using Bulk API with Inserts, Updates, and Deletes:
When the Enable Bulk Load option is enabled (EnableBulkLoad=1), the driver uses the Salesforce Bulk API for inserts, updates, and deletes based on the values of the Bulk Load Threshold connection option. If the number of affected rows exceeds the value of Bulk Load Threshold option, the driver uses the Salesforce Bulk API to execute the insert, update, or delete operation.
You can further configure bulk load behavior by specifying the number of rows the driver loads at a time using the Bulk Load Batch Size connection option. Performance can be improved by increasing the number of rows the driver loads at a time because fewer network round trips are required. Be aware that increasing the number of rows that are loaded also causes the driver to consume more memory on the client.
Using Bulk API with Selects:
When the Enable Bulk Fetch option is enabled (EnableBulkFetch=1), the driver uses the Salesforce Bulk API for selects based on the values of the Bulk Fetch Threshold connection option. If the number of rows expected in the result set exceeds the value of Bulk Fetch Threshold option, the driver uses the Salesforce Bulk API to execute the select operation.
If there is a TOP or LIMIT clause in the select query, the driver considers the TOP or LIMIT clause value as the expected number of rows in the result set and compares it with the value of the Bulk Fetch Threshold option to choose either Bulk API or REST API for executing the select query.
If the value of TOP or LIMIT clause is greater than that of the Bulk Fetch Threshold option, but the actual row count in the result set is less, the performance of the select query might be affected adversely.
