Kbase P110950: High number of hits to the system time function when creating records in a database table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/11/2005 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
SYMPTOM(s):
Creating 1000 records in a database table
Monitoring Progress process via the Truss utility
Truss utility reports +/- 3010 hits on the system time process
No field in the database table has a timestamp as its default value
Running the equivalent code against a temp-table generates only +/- 10 hits on the system time process
CAUSE:
This is expected behaviour in the current version of the product. Along with various other things like bi clusters, transaction end notes and transaction begin notes need time stamps. In addition, at commit time, the "lazy commit" timer is started, so there are three calls to time() per transaction.
CAUSE:
Enhancement Request# 20051117-023
FIX:
This Enhancement Request has not been implemented in the product