I well understand about Cache Server side and Client side.
As I understand
Entire Table: We used for Master tables.
NotInTTS: We used for Transaction tables.
Found : We used for those table where values never get changed. Like Unit Table.
Found&Empty : ?
Kindly let me know in which table we are going to set Found&Empty.
Please give me more she'd on this
Thanks!
Notintts: We used for Transaction tables
Hi, first i would thank you for above content.
Found&Empty: is used on table which by default has no record. Table like Discount table. By using Found&empty cache on discount table, the key that are queried for but not found are stored in the cache as nonexistent. So subsequent queries for these same non existent records can be answered from cache without a round trip to DB. Hoping this might help you.
Thank you
Hi @rp@n,
The CacheLookup property of the table defines how and when records are cached as shown in the following table in this link: docs.microsoft.com/.../single-record-caching You can find answer to this question in the "CacheLookup Property" section.
Not at all. As usual, you can find the explanation in documentation: Single-record Caching.
You would get answers quicker and save others' time if learned to consult AX documentation.
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156