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

●
●
●
●
●
FactoryTalk Transaction Manager User Guide
138
transactions to a smaller value or decrease the time between cache
transaction files. This will improve the timeliness of the data in your
database, but increase the load on your database.
Increasing Performance
The following sections discuss recommendations for increasing
performance when running FactoryTalk Transaction Manager
configurations.
Control System
 Store data in the control system in consecutive locations. This allows
the control data server to read and write the entire block of data one time
instead of performing several reads and writes for each transaction.
 If you must use DDE, then select AdvanceDDE instead of DDE because
AdvanceDDE is faster than CF_Text.
 Enable control system data server optimization for reads and writes.
 Use event driven communication (unsolicited messages) instead of fast
polling. For example, if the control data does not change often, set the
control system to send data only when it changes instead of
continuously polling.
 If you must poll control data, use an appropriate poll rate. For example,
do not poll every 10 milliseconds for data that is saved every 10
seconds.
Database
 Use a commercial database (e.g. Microsoft SQL Server) rather than a
personal database (such as Microsoft Access). If you choose a
Microsoft SQL Server, upgrade it to the version 2000 or later.
 Distribute the database to a different computer than the one running
FactoryTalk Transaction Manager.
 Use an appropriate data model for your application.