Scenario
We are executing a cmis query. It is taking 20 mins for first time and subsequent execution of the same query takes only milliseconds. It looks like it is caching. So, how to disable the caching?
How long the cache will retain and how to set the timeout for cache?
Is this cache user specific or application specific?
Why would you want to disable caching? The first time the query is executed is only so slow because it cannot use an existing cache entry and has to fetch a lot of data from the database. If you were to disable the cache then the second time you call the query would also take 20 minutes.
Most caches in Alfresco are global, so if one user found a specific search result than another user that finds the same result will generally profit from it performance-wise.
It is very likely that your query is simply too complex / retrieves too many records (more than what would be recommended) or that either your data model or database is not properly maintained / optimised for query performance. If you were to provide an example query (incl pagination / scope parameters) it would at least help to evaluate that...
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.