Attribute

BulkLoadJobSize (bljs)

Purpose

Determines the number of rows to load into a single job of a bulk operation when 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.

Default Value

150000