Omron NX701-1620 User Manual

Appendix B
B-4
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
B-1-2 Reference Values for Execution Time of DB Connection Instructions
The DB Connection Instructions are function block type of instructions that are executed over multiple
task periods.
The following table gives the reference values for execution time of each DB Connection Instruction.
Refer to B-2-1 Restrictions to Execution Time of DB Connection Instructions for the factors that
fluctuate execution time of DB Connection Instructions.
Conditions
DB_Insert: When executing an INSERT operation for 100-column record
DB_Select: When searching for one record from 100,000 records and retrieving 100-column data*
* The primary key is specified for the retrieval condition.
Measurement Condition 1
The following table shows the measurement conditions and items.
Measurement conditions
Description
Item
Subitem
CPU Unit Task composition Primary periodic task only
Task period: 1 ms
DB Map Variable: An internal variable of a program
Server Computer CPU: Intel Xeon(R) CPU E5-2603 @ 1.7GHz, 6 Core
Memory: 32.00GB
Operating system
Windows Server 2016 Standard 64bit
DB type Oracle Database Express Edition 11g 11.2.0
SQL Server 2016
DB2 for Linux, UNIX and Windows 10.5
MySQL Community Edition 5.6
Firebird 2.5
PostgreSQL 9.4
SQL statement to
execute
Record
composition
INT: 40 columns
REAL: 40 columns
STRING[16]: 16 columns
DATE_AND_TIME: 4 columns
Operation Logs
Execution Log
Recorded
Debug Log
Stopped
SQL Execution
Failure Log
Not recorded
 NX701-1720
DB type Instruction
Reference value
for instruction execution time
Average
Maximum
Oracle Database 11g
DB_Insert
2.4 ms
12 ms
DB_Select
5.11 ms
22 ms
SQL Server 2012
DB_Insert
2.35 ms
13 ms
DB_Select
2.62 ms
21 ms
DB2 10.5
DB_Insert
3.44 ms
21 ms
DB_Select
7.39 ms
20 ms
MySQL 5.6
Storage engine:
InnoDB
DB_Insert
15.76 ms
74 ms
DB_Select 2.21 ms 10 ms
Firebird 2.5
DB_Insert
12.95 ms
32 ms
DB_Select
21.22 ms
32 ms
PostgreSQL 9.4
DB_Insert
2.93 ms
21 ms
DB_Select
5.16 ms
14 ms

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English