FireDAC.Comp.BatchMove.TFDBatchMove.CommitCount
Delphi
property CommitCount: Integer read FCommitCount write FCommitCount default 100;
C++
__property int CommitCount = {read=FCommitCount, write=FCommitCount, default=100};
Properties
Type | Visibility | Source | Unit | Parent |
---|---|---|---|---|
property | published | FireDAC.Comp.BatchMove.pas FireDAC.Comp.BatchMove.hpp |
FireDAC.Comp.BatchMove | TFDBatchMove |
Description
Specifies how many records are batch moved before a commit occurs.
The CommitCount property is set to 100
by default. Setting CommitCount to 0
disables transaction handling.
Use CommitCount to split the batch operation into several transactions. Consider the following when choosing a CommitCount value:
- When a writing error occurs, all transactions are rolled back.
- The data movement operation is faster when the transaction is longer.
- A very long transaction may run into database transaction log limit.