922
APPX
Appendix 9 Processing Time
Database function processing time
Database operation by database access instruction
The table below lists the processing time under the following conditions:
This section shows the time taken for the completion signal of the completion device to turn on from the execution of each
instruction of the database access instructions.
*1 After power-on, initial database access involves the diagnostics to check whether the database is corrupted, and thus it takes time to
execute the DBOPEN instruction.
■For the programmable controller CPU with firmware version earlier than "28"
The table below lists the processing time under the following conditions:
This section shows the time taken for the completion signal of the completion device to turn on from the execution of each
instruction of the database access instructions.
*1 After power-on, initial database access involves the diagnostics to check whether the database is corrupted, and thus it takes time to
execute the DBOPEN instruction.
Condition 1 Condition 2
• Number of records: 10000
• Number of fields: 16
The data type of the field is WORD (6 fields), LREAL (6 fields), WSTRING
(124 characters) (3 fields), and BOOL (1 field).
• Main key: Provided
• Functions that require access to files in the SD memory card except for the
database function are not active.
• Number of records: 10000
• Number of fields: 64
The data type of the field is WORD (20 fields), LREAL (20 fields),
WSTRING (124 characters) (6 fields), and BOOL (18 fields).
• Main key: Provided
• Functions that require access to files in the SD memory card except for the
database function are not active.
Instruction Time taken to complete the execution of
instruction
Condition 1 Condition 2
Database import DBIMPORT 155s 255s
Database export DBEXPORT 75s 195s
Database connection DBOPEN First time
*1
150ms 150ms
Second time or later 105ms 105ms
Database disconnection DBCLOSE 30ms 30ms
Database record search DBSELECT 700ms 750ms
Database record addition DBINSERT 700ms 800ms
Database record update DBUPDATE 550ms 600ms
Database record deletion DBDELETE 700ms 1000ms
Condition
• Number of tables: 1
• Number of records: 10000
• Number of fields: 4
The data type of the field is specified as WORD, DWORD, WSTRING (16 characters), and WSTRING (32 characters).
• Index: specified
• Transaction: Provided (The DBINSERT/DBUPDATE/DBSELECT/DBDELETE instructions only are subject to this condition.)
• Functions that require access files in to the SD memory card except for the database access instruction are not active.
Instruction Time taken to complete the execution of
instruction
Database import DBIMPORT 320s
Database export DBEXPORT 220s
Database connection DBOPEN First time
*1
590ms
Second time or later 140ms
Database disconnection DBCLOSE 3ms
Database record search DBSELECT 180ms
Database record addition DBINSERT 210ms
Database record update DBUPDATE 260ms
Database record deletion DBDELETE 300ms
To Next Page
Loading...
