EasyManua.ls Logo

Omron NX701-1620

Omron NX701-1620
306 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Loading...
Appendix B
B-15
B
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
B-2 Execution Time of DB Connection Instructions
B-2-1 Restrictions to Execution Time of DB
Connection Instructions
NJ101-20
DB type Instruction
Reference value for
instruction execution time
Measurement condition
Oracle Database 11g DB_Insert 28.2 ms When executing an INSERT
operation for 100-column record
SQL Server 2012 DB_Insert 35.6 ms When executing an INSERT
operation for 100-column record
DB2 10.5 DB_Insert 52.7 ms When executing an INSERT
operation for 100-column record
MySQL 5.6
Storage engine: InnoDB
DB_Insert 59.3 ms When executing an INSERT
operation for 100-column record
Firebird 2.5 DB_Insert 32.6 ms When executing an INSERT
operation for 100-column record
PostgreSQL 9.4 DB_Insert 32.1 ms When executing an INSERT
operation for 100-column record
Percentage of task execution time: 50%
Countermeasures
1. Measure the execution time of the DB Connection Instruction in reference to B-1-3 How to Measure
Execution Time of DB Connection Instructions. If the execution time of the DB Connection
Instruction exceeds the acceptable range of the equipment, take the following actions.
Execute a dummy DB_Insert instruction once after executing the DB_CreateMapping instruction
as a preparation for starting the actual operation.
Phenomenon 3: When Communications or SD Memory Card Processing was
Executed in the CPU Unit, Execution Time of a DB Connection Instruction Got Longer
Possible causes
The following can be the causes:
1. The sufficient processing time may not be allocated to the DB Connection Service that is executed
as a system service due to execution of communications or SD Memory Card processing.
Countermeasures
1. Reconsider the task design so that the sufficient execution time can be allocated to the system
services in reference to B-1-4 Guideline for System Service Execution Time Ratio.
Phenomenon 4: Execution Time of DB Connection Instructions is Steadily Long
Possible causes
The following can be the causes:
1. The sufficient execution time may not be allocated to the system services.
Countermeasures
1. Reconsider the task design so that the sufficient execution time can be allocated to the system
services in reference to B-1-4 Guideline for System Service Execution Time Ratio.

Table of Contents

Related product manuals