Hi,
As we all know set-based caching in FnO caches all the table contents at Server side, according to documentation - https://docs.microsoft.com/en-us/dynamicsax-2012/developer/set-based-caching?redirectedfrom=MSDN
Question - how to change cacheLookup property value in std. table .i.e. TaxTable from EntireTable to any other? It is not possible via extensions.
The thing is, this table holds 2 million records and takes almost 10 minutes to cache it on first query after IIS reset or cache flush (which happens every 24 hrs or on insert/update/delete). It's a huge performance hit, especially for integrations when requests times out because of that.
As a work around I thought to make a batch which would select any first record from TaxTable to explicitly force caching, after AOS comes up by hooking to delegate (https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/extensibility/startup-customizations) or to CacheFlush event. And all is good there, execution takes almost 10 minutes to select the record in batch, it makes a cache, but - whenever I open TaxTable from FnO UI or make any action which queries TaxTable - again it takes 10 minutes to load the data to cache. It means only one - there are two places where tableCache is stored - one is for batch, another for user sessions or isn't it?. AOS server is one box!
Is it a bug? How can I force batch job to update table cache for UI sessions?
