Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / How long does the data...
Finance forum
Answered

How long does the data in the grid/table in the modules be cached?

Posted on by 2
Hi,
 
We have some grid/table views in Dynamics 365 F&O. How long does the data in the grid be cached? The reason I am asking is it takes a long time to load the data in the grid everyday. Does the data got clean up every day? Is there any configuration for this?
 
Please advise.
 
Categories:
  • Layan Jwei Profile Picture
    Layan Jwei 3,223 Super User on at
    How long does the data in the grid/table in the modules be cached?
    Hi Community member,
     
    Is your question answered? If yes, then please verify the answers that helped.
  • Verified answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    How long does the data in the grid/table in the modules be cached?
    Hi,
    You can refer to this official document: Record Caching | Microsoft Learn, Retrieving database records from memory instead of the database significantly speeds up data access. Caching can reduce the performance penalty for repetitively accessing the same database records. And you can also refer to this blog post: axaptamasters.com. It teaches you how to understand caching and cache lookup property of table.
    Best regards,
    Kevin
  • Verified answer
    Layan Jwei Profile Picture
    Layan Jwei 3,223 Super User on at
    How long does the data in the grid/table in the modules be cached?
    Hi Community member,
     
    There is a cache lookup property on the table which determines when data is read from the cache and when it's read from DB
     
     
    For detailed info, please check this article
     
     
    Thanks,
    Layan Jweihan
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Helpful resources

Quick Links

Contextual content recommendations & SharePoint Q&A

Instantly access relevant sales materials…

Beyond the DRA Cloud Label Printing

Explore cloud-based label printing within Dynamics 365…

HR Infrastructure Customer merge

Important considerations for HR Customer migrations…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,418 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,631 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,142

Featured topics

Product updates

Dynamics 365 release plans