topic CMIS Querying with Path having performance issues in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/cmis-querying-with-path-having-performance-issues/m-p/38692#M16287 <HTML><HEAD></HEAD><BODY><P>Hello Alfresco Community,&nbsp;</P><P></P><P>I'm starting a new Alfresco project and we are doing some tests linking Alfresco with a C-Sharp Application through&nbsp;CMIS. We have a encountered a minor setback while querying with PATHs.</P><P></P><P>I'll explain: when we execute this query without a Path we have an immediate answer:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P><SPAN style="font-size: 11.0pt; color: gainsboro;">ses</SPAN><SPAN style="font-size: 11.0pt; color: #b4b4b4;">.</SPAN><SPAN style="font-size: 11.0pt; color: gainsboro;">Query(</SPAN><SPAN style="font-size: 11.0pt; color: #d69d85;">"select&nbsp;*&nbsp;from cer<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />ocType&nbsp;where cer:statid&nbsp;=&nbsp;414"</SPAN><SPAN style="font-size: 11.0pt; color: gainsboro;">,&nbsp;</SPAN><SPAN style="font-size: 11.0pt; color: #569cd6;">false</SPAN><SPAN style="font-size: 11.0pt; color: gainsboro;">);</SPAN></P></BLOCKQUOTE><P>but when doing it like this it takes 2-3 seconds for an answer:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P><SPAN style="color: gainsboro;">ses</SPAN><SPAN style="color: #b4b4b4;">.</SPAN><SPAN style="color: gainsboro;">Query(</SPAN><SPAN style="color: #d69d85;">"select&nbsp;*&nbsp;from <SPAN style="background-color: #f6f6f6;">cer<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />ocType</SPAN> where cer:statid&nbsp;=&nbsp;414&nbsp;"</SPAN><SPAN style="color: gainsboro;">&nbsp;</SPAN><SPAN style="color: #b4b4b4;">+</SPAN><SPAN style="color: gainsboro;">&nbsp;</SPAN><SPAN style="color: #d69d85;">"&nbsp;and&nbsp;contains('PATH:\"/app:company_home/st:sites/cm:test/cm:documentLibrary/cm<img id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://connect.hyland.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />taoDoku/cm:Test//*\"')"</SPAN><SPAN style="color: #d69d85;">,&nbsp;false);</SPAN></P></BLOCKQUOTE><P>Has anybody encountered this issue? Could it be a configuration issue? We installed 5.2 out of the box...</P><P></P><P>I see a hacky way out but I want to be sure before going down that road...</P></BODY></HTML> Mon, 10 Apr 2017 14:21:24 GMT gluck113 2017-04-10T14:21:24Z CMIS Querying with Path having performance issues https://connect.hyland.com/t5/alfresco-forum/cmis-querying-with-path-having-performance-issues/m-p/38692#M16287 Hello Alfresco Community,&nbsp;I'm starting a new Alfresco project and we are doing some tests linking Alfresco with a C-Sharp Application through&nbsp;CMIS. We have a encountered a minor setback while querying with PATHs.I'll explain: when we execute this query without a Path we have an immediate answer:ses. Mon, 10 Apr 2017 14:21:24 GMT https://connect.hyland.com/t5/alfresco-forum/cmis-querying-with-path-having-performance-issues/m-p/38692#M16287 gluck113 2017-04-10T14:21:24Z Re: CMIS Querying with Path having performance issues https://connect.hyland.com/t5/alfresco-forum/cmis-querying-with-path-having-performance-issues/m-p/38693#M16288 <HTML><HEAD></HEAD><BODY><P>After discussion with <B>Axel Faust</B>‌ it seems the Path is not indexed in Solr as quickly as the metadata properties which are stored in the DB.</P><P></P><P>We must tune our Solr or put the Path in a metadata property (the hacky solution)</P></BODY></HTML> Wed, 10 May 2017 14:33:10 GMT https://connect.hyland.com/t5/alfresco-forum/cmis-querying-with-path-having-performance-issues/m-p/38693#M16288 gluck113 2017-05-10T14:33:10Z