P98613 - Database Cache

[smorrison]

I am looking for some clarification in terms of what the P98613 program actually does. Specifically I am looking to understand where this cache is held. I have read Document OTI-02-0006, and it does not explain about this question in the document. I would like to know:

1) Where this cache is held - database level? O/S Level (Logic / Client)
2) If an area other than the database, at what stage is it reset?
3) If a records is modified then are the changes recognised on the cache layer as well as the data layer?
(For example if the F0101 is in this table, users may make a cat code change that is not recognized until the user logs out and back in again)

Regards,

Stuart Morrison

 

[Tom_Davidson]

Stuart,

The answers as I understand them:

1) The cache is held by the session in memory (each client session)
2) As far as I know it is never reset.
3) Changes are recognized after you sign out of OW and log back in. (in other words, changes are never recognized by the cache)

If you use this intelligently it really isn't an issue. Just make sure that any files you cache are truly static.

Tom Davidson