FireDAC.Comp.BatchMove.TFDBatchMove.CommitCount

From Appmethod Libraries
Jump to: navigation, search

Object Pascal

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.

See Also