Omron NX701-1620 - Page 289

Appendix B
B-13
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 219 ms When executing an INSERT operation for 100-column
record
DB_Select 406 ms When searching for one record from 100,000 records
and retrieving 100-column data*
SQL Server 2012 DB_Insert 213 ms When executing an INSERT operation for 100-column
record
DB_Select 248 ms When searching for one record from 100,000 records
and retrieving 100-column data*
DB2 10.5 DB_Insert 373 ms When executing an INSERT operation for 100-column
record
DB_Select 395 ms When searching for one record from 100,000 records
and retrieving 100-column data*
MySQL 5.6
Storage engine: InnoDB
DB_Insert 219 ms When executing an INSERT operation for 100-column
record
DB_Select 245 ms When searching for one record from 100,000 records
and retrieving 100-column data*
Firebird 2.5 DB_Insert 162 ms When executing an INSERT operation for 100-column
record
DB_Select 450 ms When searching for one record from 100,000 records
and retrieving 100-column data*
PostgreSQL 9.4 DB_Insert 277 ms When executing an INSERT operation for 100-column
record
DB_Select 379 ms When searching for one record from 100,000 records
and retrieving 100-column data*
Percentage of task execution time: 50%
* The primary key is specified for the retrieval condition.
 Countermeasures
Measure the execution time of each DB Connection Instruction in reference to B-1-3 How to Measure
Execution Time of DB Connection Instructions. If the execution time of a DB Connection Instruction
exceeds the acceptable range of the equipment, take the following actions.
1. Set a timeout for the DB Connection Instruction. Refer to B-2-4 Ensuring Equipment Performance
(Takt Time) by Monitoring the Instruction Execution Timeout for details.
2. Execute a dummy DB_Insert instruction once after executing the DB_CreateMapping instruction as
a preparation for starting the actual operation.