Show: Delphi C++
Display Preferences

FireDAC.Stan.Option.TFDResourceOptions.ArrayDMLSize

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property ArrayDMLSize: Integer read GetArrayDMLSize write SetArrayDMLSize  stored IsADSS default $7FFFFFFF;

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.

See Also

Personal tools
RAD Studio 10.2 Tokyo
In Other Languages
Previous Versions
Assistance