Purpose

Determines the number of rows to load into a single job of a bulk operation when the connection property BulkLoadVersion is set to V2. Performance can be improved by increasing the number of rows the driver loads at a time because fewer network round trips are required. Increasing the number of rows also causes the driver to consume more memory on the client.

Valid Values

x

where:

x

is a positive integer less than or equal to 1000000 that represents a number of rows.

Behavior

The driver loads the specified number of rows into a single job of a bulk operation.

Data Source Methods

public Integer getBulkLoadJobSize()

public void setBulkLoadJobSize(Integer)

Default Value

150000

Data Type

Integer