Omron NX701-1620 User Manual

Appendix B
B-6
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
DB type
Percentage of
task execution
time
Instruction
Reference value
for instruction execution time
Average
Maximum
60%
DB_Insert
41.3 ms
471 ms
DB_Select
66.0 ms
433 ms
Measurement Condition 2
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.21 ms
11 ms
DB_Select
6.07 ms
14 ms
SQL Server 2012
DB_Insert
2.49 ms
8 ms
DB_Select
2.69 ms
11 ms
DB2 10.5
DB_Insert
3.11 ms
11 ms
DB_Select
10.36 ms
22 ms
MySQL 5.6
Storage engine:
InnoDB
DB_Insert
3.02 ms
11 ms
DB_Select 2.09 ms 10 ms
Firebird 2.5
DB_Insert
5.29 ms
20 ms
DB_Select
22.62 ms
57 ms
PostgreSQL 9.4
DB_Insert
2.48 ms
10 ms
DB_Select
6.75 ms
14 ms

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English