BULK support
The TwinCAT Database Server also supports so-called BULK commands for a selection of databases. BULK commands are SQL statements that insert collected data into multiple rows of a table. Using BULK insert commands usually results in better performance than processes that send a single insert statement to the database for each row to be added.
Currently, BULK commands via the FB_PLCDBCmdEvt function block are supported by the TwinCAT Database Server for Microsoft SQL databases.
Example command: 'SQLBULK<INSERT>#MyTable‘