Phenomenon 5: Depending on the DB’s Status, Execution Time of a DB Connection
Instruction (i.e., DB_Insert, DB_Update, DB_Select, or DB_Delete Instruction Got
Longer.
Possible causes
The following can be the causes:
1. Load on the server was temporarily increased.
2. The specified table contains many records.
3. The data clear operation was executed for the specified table.
4. The specified table was temporarily locked.
Countermeasures
Measure the processing time in the DB in reference to B-2-3 How to Measure DB Response Time.
Identify the cause based on the timing when the processing time got longer in the DB and take a
countermeasure in the server.
To Next Page
Loading...
