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 / Small and medium business | Business Central, N... / Record Caching and Cac...
Small and medium business | Business Central, N...
Answered

Record Caching and Cache Size

(0) ShareShare
ReportReport
Posted on by Rbansode 5

In the Data Access section of Microsoft Docs, I have noticed that it mentions that 

For a call to any of the FIND functions, 1024 rows are cached. You can set the size of the cache by using the Data Cache Size setting in the Business Central Server configuration file. The default size is 9, which approximates a cache size of 500 MB. If you increase this number by one, then the cache size doubles.

Does that mean, if I increase the cache size, the number of records that will be cached will also increase?

Furthermore, there are no mentions of the Upper limit of what this could be and how many records can be possibly cached.

Any help would be appreciated!

Data Access - Business Central | Microsoft Docs

I have the same question (0)
  • Lars Lohndorf-Larsen Profile Picture
    Lars Lohndorf-Larsen on at
    RE: Record Caching and Cache Size

    Hello,

    Thank you for asking this. First of all, refer to http://aka.ms/bcperformance - in this case specifically the section for developers, where there are some interesting tips about performance.

    Regarding the CacheSize parameter, please just be careful - increment it by 1 at the time, then see if that helps. I think the largest I have seen, is 13. But as memory udage doubles every time, it is an exponential RAM consumer. So go carefully between 9 and 13, and watch for effects after each change.

    I hope this helps even if I cannot give you a max? And also if you are coming from a situation of performance issues, then also look further than just adding memory to the BC Server - if you have some specific issues, then share and maybe there is other advice to be shared.

  • Rbansode Profile Picture
    Rbansode 5 on at
    RE: Record Caching and Cache Size

    Hi Lars,

    Thank you for your response.

    While I do understand that incrementing the CacheSize parameter, will double the cache storage, does the same happen with the number of records held in the cache? Like initially, 1024 records are stored in the cache by default but if we go from Cache Size 9 to 10 does that mean we can store twice as many records in the cache?

  • Verified answer
    Lars Lohndorf-Larsen Profile Picture
    Lars Lohndorf-Larsen on at
    RE: Record Caching and Cache Size

    Hi Rahul,

    Twice as much data yes, but different tables have different record sizes, so not necessarily twice as many records. Record size depends on number of fields on the record, number of indexes in the table, and data types, especially if you have BLOB fields on the table.

    "Table Informatin", available here in the web client since (afaik) BC170: MyPC:8080/.../ shows a good picture of number of records, and the size of data in each table.

    hth?

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,160

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,943

#3
Sumit Singh Profile Picture

Sumit Singh 2,823

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans