topic Cmis query caching in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/cmis-query-caching/m-p/24745#M10744 <HTML><HEAD></HEAD><BODY><P>Scenario</P><P></P><P>We are executing a cmis query. &nbsp;It is taking 20 mins for first time and subsequent execution of the same query takes only milliseconds. &nbsp;It looks like it is caching. &nbsp;So, how to disable the caching?</P><P>How long the cache will retain and how to set the timeout for cache?</P><P>Is this cache user specific or application specific?</P></BODY></HTML> Tue, 25 Jul 2017 15:35:14 GMT dinesh_rajan 2017-07-25T15:35:14Z Cmis query caching https://connect.hyland.com/t5/alfresco-forum/cmis-query-caching/m-p/24745#M10744 ScenarioWe are executing a cmis query. &nbsp;It is taking 20 mins for first time and subsequent execution of the same query takes only milliseconds. &nbsp;It looks like it is caching. &nbsp;So, how to disable the caching?How long the cache will retain and how to set the timeout for cache?Is this cache user specifi Tue, 25 Jul 2017 15:35:14 GMT https://connect.hyland.com/t5/alfresco-forum/cmis-query-caching/m-p/24745#M10744 dinesh_rajan 2017-07-25T15:35:14Z Re: Cmis query caching https://connect.hyland.com/t5/alfresco-forum/cmis-query-caching/m-p/24746#M10745 <HTML><HEAD></HEAD><BODY><P>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.</P><P>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.</P><P></P><P>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...</P></BODY></HTML> Wed, 26 Jul 2017 10:24:11 GMT https://connect.hyland.com/t5/alfresco-forum/cmis-query-caching/m-p/24746#M10745 afaust 2017-07-26T10:24:11Z