So we have a NST cache which will cache allot of frequent asked resultsets (based on cachesize)
and we have an SQL server that caches what it thinks is right.
These caches are very nice, but when you have a expensive calculation which involves allot of queries and allot of setup, its really nice to keep allot of those data that does not change that much but is needed in a single instance.. it speeds things up allot.
But webservice calls and odata Function calls do not actually benefit from this single instance way of your own cache.
it has to read for every single call all the data to make its expensive calculation based on allot of parameters
Or
needs to read a mapping table all te time
Or what about a expensive query to show something nice in the dashboard of every user..
such a wased.. of time and of filling the cache of SQL with this data instead of the actual data that i cannot predict to cache.
could we please have a possibility to put something in a cache at NST level
so we could choose to cache certain data for all users to perform faster, and webcalls etc.
I know MS has it somewhere on there list, but not as high priority. So please give a vote!!
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team