Querying _userio VST table

Posted by Jayaprakash Jayakumar on 09-Jan-2017 07:34

Hi ,

Can you please clarify about _userio-dbaccess  & _userio-dbread   ? what is the difference between those 2 fields ?

Thanks ,

OpenEdge General - Forum

All Replies

Posted by Valeriy Bashkatov on 09-Jan-2017 07:43

[quote]

_UserIO-DbAccess

Number of database access operations performed by the process

Counts the number of times that database connection accessed the database cache buffer in memory, either to retrieve data from it (for example, a record fetch or an index lookup) or to update it (for example, to do a record create, delete or update, index insert). The purpose of the buffer cache is to minimize the need for disk I/O operations which are expensive as they are much more time consuming than accessing data already in shared- memory.
        

_UserIO-DbRead 

Number of database read operations performed by the process

Counts the number of times a database connection had to read a block from disk because it was not already present in the buffer cache. In most cases, after a database block has been read into the buffer cache, it is accessed multiple times, possibly by many different users (database connections), without requiring additional disk transfers. 

[/quote]

knowledgebase.progress.com/.../P74425

This thread is closed