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

(1) Share

Report

Posted on by CU27040846-1

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.

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Layan Jwei 8,284 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Layan Jwei 8,284 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Community member,

Is your question answered? If yes, then please verify the answers that helped.

Was this reply helpful? Yes No