Rockwell-automation FactoryTalk Transaction Manager User Guide Instrukcja Użytkownika Pobierz pdf (Strona 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.

1 2 ... 134 135 136 137 138 139 140 141 142 143 144 ... 185 186

Brak uwag

Rockwell-automation FactoryTalk Transaction Manager User Guide Instrukcja Użytkownika Strona 139