hi
what is mean by cache lookup in table property? what are the uses?plz explain in details?
you can see the following link it describe the Dynamics AX Caching very well
Go thorugh this link :
http://kashperuk.blogspot.in/2007/07/fetching-data-experiment-cachelookup.html
It is a property that helps avoid database access when it’s not strictly necessary. Retrieving database records from memory instead of the database significantly speeds up data access.
Found: If a table is accessed through a primary key or a unique index, the value is cached for the duration of the session or until the record is updated. If another instance of the AOS updates this record, all AOS instances will flush their caches.
This cache setting is appropriate for master data.
NotInTTS: Works the same way as Found, except that every time a transaction is started, the cache is flushed and the query goes to the database. This cache setting is appropriate for transactional tables.
FoundAndEmpty: Works the same way as Found, except that if the query cannot find a record, the absence of the record is stored. This cache setting is appropriate for region-specific master data or master data that isn’t always present.
EntireTable: The entire table is cached in memory on the AOS, and the client treats this cacheas Found. This cache setting is appropriate for tables with a known number of limited records, such as parameter tables.
None: No caching occurs. This setting is appropriate in only a few cases, such as when