FireDAC.Stan.Option.TFDResourceOptions.ArrayDMLSize
Delphi
property ArrayDMLSize: Integer read GetArrayDMLSize write SetArrayDMLSize
C++
__property int ArrayDMLSize = {read=GetArrayDMLSize, write=SetArrayDMLSize, stored=IsADSS, default=2147483647};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | FireDAC.Stan.Option.pas FireDAC.Stan.Option.hpp |
FireDAC.Stan.Option | TFDResourceOptions |
Description
Limits the maximum possible Array DML array size.
Set ArrayDMLSize to the maximum possible Array DML size, which is supported by the target DBMS. By default, the array DML size is unlimited (MAXINT).
If the actual array DML size is greater than ArrayDMLSize, then FireDAC will transparently split one big batch into a few smaller ones, where each will be of ArrayDMLSize size or less. Some DBMSs (Firebird, MS SQL Server) have problems with large array DML sizes. If you experience some peculiar problems with array DML, then try to set ArrayDMLSize.