FireDAC.Comp.BatchMove.TFDBatchMove.CommitCount
| [–] Properties | |
|---|---|
| Type: property | |
| Visibility: published | |
| Source: FireDAC.Comp.BatchMove.pas FireDAC.Comp.BatchMove.hpp
| |
| Unit: FireDAC.Comp.BatchMove | |
| Parent: TFDBatchMove | |
Delphi
property CommitCount: Integer read FCommitCount write FCommitCount default 100;
C++
__property int CommitCount = {read=FCommitCount, write=FCommitCount, default=100};
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.