Omron NX701-1620

Appendix B
B-14
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Phenomenon 2: After Execution of a DB_CreateMapping Instruction, Execution Time
of the First DB_Insert Instruction Got Longer
 Possible causes
The following can be the causes:
1. For the first DB_Insert instruction that is executed after execution of a DB_CreateMapping
instruction, the DB may require longer processing time than usual.
The following table gives the reference values for execution time of the first DB_Insert instruction that is
executed after execution of a DB_CreateMapping instruction.
 NX701-20
DB type Instruction
Reference value for
instruction execution time
Measurement condition
Oracle Database 11g DB_Insert 3.32 ms When executing an INSERT
operation for 100-column record
SQL Server 2012 DB_Insert 6.04 ms When executing an INSERT
operation for 100-column record
DB2 10.5 DB_Insert 86.08 ms When executing an INSERT
operation for 100-column record
MySQL 5.6
Storage engine: InnoDB
DB_Insert 21.13 ms When executing an INSERT
operation for 100-column record
Firebird 2.5 DB_Insert 5.31 ms When executing an INSERT
operation for 100-column record
PostgreSQL 9.4 DB_Insert 8.69 ms When executing an INSERT
operation for 100-column record
 NJ501-20
DB type Instruction
Reference value for
instruction execution time
Measurement condition
Oracle Database 11g DB_Insert 29.9 ms When executing an INSERT
operation for 100-column record
SQL Server 2012 DB_Insert 17.5 ms When executing an INSERT
operation for 100-column record
DB2 10.5 DB_Insert 26.4 ms When executing an INSERT
operation for 100-column record
MySQL 5.6
Storage engine: InnoDB
DB_Insert 41.7 ms When executing an INSERT
operation for 100-column record
Firebird 2.5 DB_Insert 22.5 ms When executing an INSERT
operation for 100-column record
PostgreSQL 9.4 DB_Insert 14.1 ms When executing an INSERT
operation for 100-column record