News and Announcements icon

Dynamics 365 CommunityForums Finance forum How long does the data...

Finance forum

Answered

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

(1) Share

Report

Report

Posted on by Community member

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:

All responses Img

All responses (3)

Answers Img

Answers (2)

Layan Jwei 4,845 Super User on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 4,845 Super User on at

Like (0)

Report

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

https://d365ffo.com/2021/04/15/d365ffo-ax-cache-lookup-property-of-table/comment-page-1/#:~:text=Caches%20are%20used%20on%20both,round%20trips%20and%20DB%20calls.

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

Leaderboard

#1

André Arnaud de Cal... 288,768 Super User

#2

Martin Dráb 225,985 Super User

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans