Omron NX701-1620 User Manual

Appendix B
B-18
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
B-2-3 How to Measure DB Response Time
The DB response time refers to the time since an SQL statement is sent from the CPU Unit until the
SQL execution result is returned from the DB. You can find the DB response time by executing a
DB_GetConnectionStatus instruction after executing an instruction that sends an SQL statement.
An example user program is given below.
 Measurement example of DB response time for a DB_Insert instruction
Find the DB response time for a DB_Insert instruction.
Operating
DB_GetConnectionStatus_instance
Execute
DBConnectionName
DB_GetConnectionStatus
Done
Busy
Error
ErrorID
ConnectionStatus
MyStatus
‘MyDatabase1’
DB_Insert_instance
MyDB1
MapVar_Insert
Execute
DBConnection
MapVar
TimeOut
DB_Insert
Done
Busy
Error
ErrorID
SendStatus
Normal end processing
Operating DB_GetConnectionStatus_instance.Done
// Output the DB response time to DB1ResTime[] variable.
DB1ResTime[index] := MyStatus.DBResTime;
Index := index + 1;
IF index = 1000 THEN
Index := 0;
END_IF;
DB_Insert_instance.Done
You can also check the DB response time with the Execution Log or Debug Log.

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English