The InsertCommitSize property specifies the number of rows that are inserted in a single transaction when the FastLoad option is being used.
object.InsertCommitSize [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Number of rows inserted as a single transaction |
Long
Read/write
HRESULT GetInsertCommitSize(LONG *pRetVal);
HRESULT SetInsertCommitSize(LONG NewValue);
The default is 0. This means all inserts into the table are batched in a single transaction.