skip to main content
Connection Property Descriptions : BulkLoadBatchSize
  

Try DataDirect Drivers Now

BulkLoadBatchSize

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

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.

Data Source Method

setBulkLoadBatchSize

Default

1000 (rows)

Data Type

long

See also

DataDirect Bulk Load