
I was reading about Caching in Business Central and I noticed that it mentions that Query Object and it's results are not cached in Business Central.
In the subsequent lines, it mentioned "Query result sets are not guaranteed to be dynamic, whereas record result sets are always dynamic."
I do not understand, why this hinders caching and why is this the way it is?
Can someone help me understand?
Query Objects and Performance - Business Central | Microsoft Docs
Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.
dynamicsuser.net/.../developers
I will open this up to the community in case they have something to add.