Purpose

Provides a suggestion to the driver for the number of rows to load at a time when bulk loading data. 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.

Valid Values

x

where:

x
is a positive integer that represents a number of rows.

Behavior

If set to x, the driver loads the specified number of rows at a time. If the specified value exceeds the maximum batch size allowed by the data source, the driver uses the maximum batch size allowed by the data source.

Notes

  • The batchSize() method of the DDBulkLoad interface can be used to override this value for a particular bulk load operation.

Default

1000 (rows)

Data Type

long

See also

Using DataDirect Bulk Load