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

(1) Share

Report

Posted on by Community member

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.

All responses (3)

Answers (2)

Layan Jwei 7,264 Super User 2024 Season 2 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 7,264 Super User 2024 Season 2 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