web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Cache lookup property
Finance forum

Cache lookup property

(0) ShareShare
ReportReport
Posted on by 30

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

I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    237,002 Most Valuable Professional on at
    RE: Cache lookup property

    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.

  • Verified answer
    Jie G Profile Picture
    on at
    RE: Cache lookup property

    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.

  • Rahul606 Profile Picture
    5 on at
    RE: Cache lookup property

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans