|
Option
|
Characteristic
|
|
Specifies a number of rows that, if exceeded, signals the driver to use the Salesforce Bulk API for select operations. For this behavior to take effect, the Enable Bulk Fetch option must be set to 1 (enabled).
If set to 0, the driver uses the Salesforce Bulk API for all select operations.
If set to x, the driver uses the Salesforce Bulk API for select operations when the value of x is exceeded.
Default: 30000 (rows)
|
|
|
The number of rows that the driver sends to the database at a time during bulk operations.
Default: 1024
|
|
|
Determines whether multiple batches associated with a bulk load operation are processed by Salesforce in parallel or one at a time.
If set to 0 (Serial), multiple batches associated with a bulk load operation are processed one at a time.
If set to 1 (Parallel), multiple batches associated with a bulk load operation are processed in parallel. The order in which the batches are processed can vary.
Default: 1 (Parallel)
|
|
|
Determines when the driver uses bulk load for insert, update, and deletes.
If set to 0, the driver always uses bulk load to execute insert, update, and deletes.
If set to x, the driver only uses bulk load if the Enable Bulk Load option is set to a value of 1 (enabled) and the number of rows to be updated by an insert, update, or delete exceeds the threshold. If the operation times out, the driver returns an error.
Default: 4000
|
|
|
The time, in seconds, that the driver waits for a Salesforce bulk job to complete.
A value of zero means there is no timeout.
Default: 0
|
|
|
Specifies whether the driver can use the Salesforce Bulk API for selects based on the value of the Bulk Fetch Threshold connection option.
If set to 1 (Enabled), the driver can use the Salesforce Bulk API for selects based on the value 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 set to 0 (Disabled), the driver does not use the Salesforce Bulk API, and the Bulk Load Threshold option is ignored.
Default: 1 (Enabled)
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.
|
|
|
Specifies whether the driver can use the Salesforce Bulk API for inserts, updates, and deletes based on the value of the Bulk Load Threshold connection option.
If set to 1 (Enabled), the driver can use the Salesforce Bulk API for inserts, updates, and deletes based on the value 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.
If set to 0 (Disabled), the driver does not use the Salesforce Bulk API, and the Bulk Load Threshold option is ignored.
Default: 1 (Enabled)
|
|
|
Specifies whether the driver uses PK chunking for select operations. PK chunking breaks down bulk fetch operations into smaller, more manageable batches for improved performance.
If set to 1 (Enabled), the driver uses PK chunking for select operations when the expected number of rows in the result set is greater than the values of the Bulk Fetch Threshold and Primary Key Chunk Size options. For this behavior to take effect, the Enable Bulk Fetch option must also be set to 1 (enabled).
If set to 0 (Disabled), the driver does not use PK chunking when executing select operations, and the Primary Key Chunk Size option is ignored.
Default: 1 (Enabled)
|
|
|
Specifies the size, in rows, of a primary key (PK) chunk when PK chunking has been enabled via the Enable Primary Key Chunking option. The Salesforce Bulk API splits the query into chunks of this size.
Default: 100000 (rows)
|