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.