Kbase P129715: 4GL/ABL: An Extra read is being recorded in _tablestat._tablestat-read.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/09/2009 |
|
Status: Verified
SYMPTOM(s):
4GL/ABL: An Extra read is being recorded in _tablestat._tablestat-read.
When running the following code, the number of reads for the Customer table is inaccurately reported as 2 and not a as expected:
FIND FIRST customer.
FIND FIRST _tablestat WHERE _tablestat._tablestat-id = 2 NO-ERROR.
MESSAGE _tablestat._tablestat-read
VIEW-AS ALERT-BOX INFO BUTTONS OK.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
The product functions as designed. See the discussion detaiuls in the fix below.
FIX:
These statistcs represent storage engine accesses, not application Reads. A single application read can result in one or more storage engine accesses, depending on both how the data is defined in the application and how the database is configured. Using this number for application tuning is looking at only one aspect of the overall picture. In the case where the minimum record size parameter causes the "customer" record buffer being passed to the storage engine to be too small and a re-read to be executed, this is truly two reads on the storage engine. For performance tuning you will need to know that your application is resulting in more accesses than the number of read statements. To only count one access would understate the storage engine activity.