Purpose

Specifies whether the driver uses the native bulk load protocols in the database instead of the batch mechanism for batch inserts. Bulk load bypasses the data parsing usually done by the database, providing an additional performance gain over batch operations. This property allows existing applications with batch inserts to take advantage of bulk load without requiring changes to the application code.

Valid Values

true | false

Behavior

If set to true, the driver uses the native bulk load protocols for batch inserts.

If set to false, the driver uses the batch mechanism for batch inserts.

Notes

  • If set to true, any value set for BatchPerformanceWorkaround is ignored.

Default

false

Data Type

boolean

See also

Using DataDirect Bulk Load

Performance Considerations