CGI Advantage provides the ability to keep mostly static reference data in memory for fast and efficient access. It supports two varieties of this feature: Memory Resident Table (MRT) and Server Data Object Cache (SDO). The technical implementation of these two features is quite different despite the conceptual similarities.
It is more efficient for the system to load frequently accessed but infrequently updated tables into memory. Any data requests for such tables can be serviced from memory instead of making expensive database calls. Such tables in the system can be marked as being either MRT or SDO.
The following topics describe the MRT and SDO features of the CGI Advantage system. The topics also detail what system administrators need to be aware of when a table has to use either the MRT or SDO feature.