Caching

The previous sections have discussed how to optimize communication with the
database by structuring SQL statements that make the database access data in the
correct way. But the most optimal strategy is to have no communication with the
database or to minimize the number of communications with the database server.
The concept of caching is to remember the information retrieved from the
database and use this memory when the same data is needed at a later time.
However, this strategy has one large drawback, if the remembered information is
no longer valid, this could compromise the consistency of the database, as the
updates will be made based on invalid data.
This section covers data caching done by Microsoft Dynamics AX AOS and/or
client. Microsoft Dynamics AX supports the following kinds of caching:• Read-ahead caching• Single-record caching• Entire table caching• Record view caching• Display method caching• Global object cache• Date effective join cache• Unique index cache extension• Cache lookup for table groups
The remainder of this section explains the first five above mentioned data
catching .

Best Regards,
Hossein Karimi