Outsystems Advance Query Cache in Minutes

Hi Guys,

Need your guidance on this. I have a listing(with search functionality line count per pagination is set to 50) where in it returns huge amount of data. We already check the query and optimized it as much as possible. I have check that there is this property where in you can set the Cache in Minutes but I notice that if there is a NEW record or a certain field was updated it does not force the CACHE to Clear as a result you are getting the not updated record.

Is there a way for us to force the query to clear the cache and get another set of new record from the table when there is an update on the table and cache it again? Or any other suggestions to improve searching performance?

I am currently using Version 11


Thank you



This should help : 

https://www.outsystems.com/help/servicestudio/9.0/Improving_Runtime_Performance/Caching_Contents/Invalidating_the_Cache.htm


You'll have to invalidate the current cache which will force the Advanced SQL query to re-execute. 

Tushar Panpaliya wrote:

This should help : 

https://www.outsystems.com/help/servicestudio/9.0/Improving_Runtime_Performance/Caching_Contents/Invalidating_the_Cache.htm


You'll have to invalidate the current cache which will force the Advanced SQL query to re-execute. 

I am currently using version 11.

Will this invalidate all cache per user? What i need is to only invalidate the cache for a specific query...


Hi,

You can only invalidate cache of an espace or tenant. On your case, to keep using cache, the best you can do is invalidate cache of the query espace.

Hi Michael,

The query results are cached on the front end (application) server - it is totally agnostic of what goes on in the database. There is no way to invalidate the cached data (save from invalidating the eSpace cache, but that could make everything slower for a while), let alone do that when something is changed in the database.