Rockwell Automation FactoryTalk Transaction Manager User Guide - Manual (Page 69)

4
●
Understanding FactoryTalk Transaction Manager Services
●
●
●
●
●
69
executing to the database fast enough. To make a transaction use
real-time threads, select Use Real Time Thread on the Transaction
Definition dialog box.
 SQL buffer size: Specifies the size of the SQL buffer in kilobytes. The
SQL buffer specifies the number of bytes necessary to build the
command that will be executed. The default value only needs to be
modified if database errors occur and the SQL file shows only a partial
command.
 Maximum transactions per file: Indicates that a file is sent to the
enterprise connector for processing when Maximum Transactions Per
File or Maximum Time Between Files value is reached, whichever
comes first. Setting this value to a field greater than 1 allows the
enterprise connector to use array inserts on databases that support them.
Array inserts increase database performance by allowing multiple
inserts/updates in a single database command.
 Maximum time between files: Indicates that a file is sent to the
enterprise connector for processing when the Maximum Time Between
Files or Maximum Transactions Per File is reached, whichever comes
first.
FactoryTalk Transaction Manager Service
The FactoryTalk Transaction Manager service performs the following tasks:
 Controls the execution of all FactoryTalk Transaction Manager
transactions.
 Collects and sends data to and from all of the connector services.
 Controls the scheduling and execution of the transactions.
 Controls data manipulation, if required.