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

9
●
Exploring Advanced Topics
●
●
●
●
●
139
 Tune the database. Understand when to use indices and how to archive
data. Consult your database administrator for assistance.
 Optimize queries, triggers, and stored procedures executed by
FactoryTalk Transaction Manager.
FactoryTalk Transaction Manager
 Trigger transactions on unscheduled data change instead of scheduled
transaction execution.
 If you must use DDE, select hot links instead of cold links to the control
data server.
 Use FactoryTalk Device Scheduled collection mode, which improves
data accuracy and reduces network traffic.
This collection mode will cause transactions to run slower.
 Distribute both control connectors and enterprise connectors on
multiple computers.
 When using real-time transactions, use multiple real-time threads. The
disadvantage is that this consumes extra connections to the database.
Some databases are licensed based on the number of simultaneous
connections.
 Use an Oracle OCI connection instead of an ODBC connection to an
Oracle database.
 Use cached transaction files instead of real-time threads, which
enhances database performance on commercial databases that allow
―array inserts.‖
 Modify the cached transaction file parameters (number of transactions
per log file and time between cache files) to optimize the scheduling and
volume of transactions to your database.
 Disable debug error logging in FactoryTalk Transaction Manager.