Omron NX701-1620 - Page 281

Appendix B
B-5
B
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
 NJ501-1520
DB type
Percentage of
task execution
time
Instruction
Reference value
for instruction execution time
Average
Maximum
Oracle Database 11g 50%
DB_Insert
16.2 ms
65 ms
DB_Select
37.1 ms
75 ms
80%
DB_Insert
49.2 ms
184 ms
DB_Select
101.6 ms
272 ms
SQL Server 2012 50%
DB_Insert
16.1 ms
57 ms
DB_Select
23.8 ms
98 ms
80%
DB_Insert
45.5 ms
112 ms
DB_Select
72.5 ms
236 ms
DB2 10.5 50%
DB_Insert
27.5 ms
115 ms
DB_Select
37.1 ms
80 ms
80%
DB_Insert
69.4 ms
176 ms
DB_Select
99.5 ms
352 ms
MySQL 5.6
Storage engine:
InnoDB
50%
DB_Insert
40.3 ms
273 ms
DB_Select
32.0 ms
41 ms
80%
DB_Insert
65.0 ms
315 ms
DB_Select
69.4 ms
164 ms
Firebird 2.5 50%
DB_Insert
23.8 ms
156 ms
DB_Select
71.7 ms
153 ms
80%
DB_Insert
52.8 ms
139 ms
DB_Select
118.4 ms
234 ms
PostgreSQL 9.4 50%
DB_Insert
17.0 ms
78 ms
DB_Select
30.9 ms
83 ms
80%
DB_Insert
48.3 ms
175 ms
DB_Select
89.1 ms
250 ms
 NJ101-1020
DB type
Percentage of
task execution
time
Instruction
Reference value
for instruction execution time
Average
Maximum
Oracle Database 11g 50%
DB_Insert
27.8 ms
311 ms
DB_Select
42.0 ms
311 ms
60%
DB_Insert
39.0 ms
342 ms
DB_Select
62.4 ms
369 ms
SQL Server 2012 50%
DB_Insert
26.7 ms
287 ms
DB_Select
36.2 ms
626 ms
60%
DB_Insert
37.5 ms
621 ms
DB_Select
52.1 ms
456 ms
DB2 10.5 50%
DB_Insert
39.8 ms
544 ms
DB_Select
59.0 ms
467 ms
60%
DB_Insert
52.3 ms
397 ms
DB_Select
81.0 ms
655 ms
MySQL 5.6
Storage engine:
InnoDB
50%
DB_Insert
44.2 ms
365 ms
DB_Select
36.0 ms
599 ms
60%
DB_Insert
54.6 ms
834 ms
DB_Select
52.4 ms
450 ms
Firebird 2.5 50%
DB_Insert
34.0 ms
314 ms
DB_Select
78.4 ms
403 ms
60%
DB_Insert
45.4 ms
388 ms
DB_Select
101.0 ms
472 ms
PostgreSQL 9.4 50%
DB_Insert
28.7 ms
306 ms
DB_Select
45.0 ms
291 ms
B-1 Task Design Procedure
B-1-2 Reference Values for Execution Time of DB Connection Instructions