BatchSize Property

       

Returns or sets a value that specifies the number of statements sent back to the server in each batch.

Syntax

object.BatchSize [= value]

The BatchSize property syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
value A Long integer representing the number of statements sent back to the server in each batch. The default value is 15.

Remarks

This property determines the batch size used when sending statements to the server during an optimistic batch update. The value of the property determines the number of statements sent to the server in one command buffer. By default, 15 statements are sent to the server in each batch. This property can be changed at any time. If a DBMS doesn’t support statement batching, you can set this property to 1, causing each statement to be sent separately.