I am not sure If this is currently supported or not. But I want to know if we can Cache the Data in Aggregates. Also there should be cache time for some instances. This would help for quickly populating legacy/old data on Page. Also there should be mechanism to check for updates in Aggregated Data and only relevant Data should be re-fetched or updated.
Hi @Pradnya Joshi,
I believe we already have cache on server side aggregates.
You can also configure the time of the cached information.
For more information please refer the below documentation.
https://success.outsystems.com/documentation/11/reference/outsystems_language/data/handling_data/queries/aggregate/https://success.outsystems.com/documentation/11/developing_an_application/use_data/caching/
Best Regards,Vignesh Prakash.
This feature already exists for many years in OutSystems as stated in the reply given.
Thanks Vignesh. I will check that. Thanks Daniel. It seems Data compare and relevant re-fetching is what looks Out Of Scope for now. Let's see if we can have that feature in future.
"Also there should be mechanism to check for updates in Aggregated Data and only relevant Data should be re-fetched or updated."
How would this ever work, it is counter productive on the caching principal, you would always need to query the database to find out if there is or not is a change.
Caching is for data you expect not to change within a certain interval. If you expect changes, you should not cache it.