Configuring Bulk Load
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Because MySQL does not have native bulk load support, the MySQL driver emulates bulk load using the standard batch mechanism. See Using a DDBulkLoad Object for more information.
Only one connection property affects how bulk load works with the MySQL driver (see the following table).
| Property | Description |
|---|---|
| BulkLoadBatchSize | Provides a suggestion to the driver for the number of rows to load to
the database at a time when bulk loading data. The default is
1000. |