Purpose

Specifies the maximum number of rows sent to the service when an insert, update, or delete operation impacts multiple rows.

Valid Values

x

where:

x

is a number of rows greater than or equal to 1.

Notes

This property can impact performance by reducing the number of round trips required to complete an insert, update, or delete operation. For example, at the default setting of 200 rows, a 10,000 row insert operation would require 50 round trips. Setting BatchUpdateChunkSize to 500 rows would reduce the number of round trips to 20.

Data Source Methods

public Integer getBatchUpdateChunkSize()

public void setBatchUpdateChunkSize(Integer)

Default Value

200

Data Type

Integer