Omron NX701-1620

Appendix B
B-12
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
The following table gives the reference values for execution time of the first DB Connection Instruction
after the power supply to the CPU Unit is turned ON.
 NX701-1720
DB type Instruction
Reference value for
instruction execution time
Measurement condition
Oracle Database 11g DB_Insert 99 ms When executing an INSERT operation for 100-column
record
DB_Select 72 ms When searching for one record from 100,000 records
and retrieving 100-column data*
SQL Server 2012 DB_Insert 312 ms When executing an INSERT operation for 100-column
record
DB_Select 63 ms When searching for one record from 100,000 records
and retrieving 100-column data*
DB2 10.5 DB_Insert 145 ms When executing an INSERT operation for 100-column
record
DB_Select 123 ms When searching for one record from 100,000 records
and retrieving 100-column data*
MySQL 5.6
Storage engine: InnoDB
DB_Insert 130 ms When executing an INSERT operation for 100-column
record
DB_Select 78 ms When searching for one record from 100,000 records
and retrieving 100-column data*
Firebird 2.5 DB_Insert 10 ms When executing an INSERT operation for 100-column
record
DB_Select 43 ms When searching for one record from 100,000 records
and retrieving 100-column data*
PostgreSQL 9.4 DB_Insert 25 ms When executing an INSERT operation for 100-column
record
DB_Select 27 ms When searching for one record from 100,000 records
and retrieving 100-column data*
 NJ501-20
DB type Instruction
Reference value for
instruction execution time
Measurement condition
Oracle Database 11g DB_Insert 124 ms When executing an INSERT operation for 100-column
record
DB_Select 175 ms When searching for one record from 100,000 records
and retrieving 100-column data*
SQL Server 2012 DB_Insert 136 ms When executing an INSERT operation for 100-column
record
DB_Select 130 ms When searching for one record from 100,000 records
and retrieving 100-column data*
DB2 10.5 DB_Insert 315 ms When executing an INSERT operation for 100-column
record
DB_Select 839 ms When searching for one record from 100,000 records
and retrieving 100-column data*
MySQL 5.6
Storage engine: InnoDB
DB_Insert 62 ms When executing an INSERT operation for 100-column
record
DB_Select 38 ms When searching for one record from 100,000 records
and retrieving 100-column data*
Firebird 2.5 DB_Insert 35 ms When executing an INSERT operation for 100-column
record
DB_Select 175 ms When searching for one record from 100,000 records
and retrieving 100-column data*
PostgreSQL 9.4 DB_Insert 87 ms When executing an INSERT operation for 100-column
record
DB_Select 111 ms When searching for one record from 100,000 records
and retrieving 100-column data*