Summary of related options for bulk load for batch inserts
- Last Updated: October 28, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Database Wire Protocol 8.0
- Documentation
| Connection Options: Bulk | Description |
|---|---|
| Batch Size (BulkLoadBatchSize) | The number of rows that the driver sends
to the database at a time during bulk operations. This value applies to all methods of
bulk loading. Default: 1024 |
| Enable Bulk Load (EnableBulkLoad) | Specifies the bulk load method. If enabled, the driver uses the database bulk load protocol when an application executes an INSERT with multiple rows of parameter data. If the protocol cannot be used, the driver returns a warning. If disabled, the driver uses standard parameter arrays. Default: Disabled |
See "Connection option descriptions" for details about configuring the options.