The Cache class provides a mechanism for read-only database activity on frequently-used tables to be resolved in local processor memory, minimizing physical database IO. This is a significant technique for applications that frequently access the same row(s), such as product tables in batch functions and transaction tables in transaction processing functions.
This feature may benefit relational databases more than M databases, due to inherent global buffering in M. However, the feature can be implemented generally.
For examples, refer to the Cache class and the ‘Gold Standard’ procedure TRNDRV and batch BTTDRV.