topic Alfresco JCR xpath search in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144656#M101146 <HTML><HEAD></HEAD><BODY><SPAN>I've quite successfully used the Alfresco JCR-JNDI Bridge found in Jira. </SPAN><BR /><BR /><SPAN>My problem is with QueryManager xpath query performance. It seems that no matter how simple query I make it always takes around 30 seconds to complete which is completely unacceptable. </SPAN><BR /><BR /><SPAN>Here is a sample query //app:company_home/dws:Folder1/dsw:Folder2/element(*, dws:article)</SPAN><BR /><BR /><SPAN>dws:Folder1 and dws:Folder2 are custom model types that extend cm:folder and dws:article is a custom type that extends cm:content</SPAN><BR /><BR /><SPAN>dws:Folder2 has 6 items.</SPAN><BR /><BR /><SPAN>I found this old forum post </SPAN><A href="http://forums.alfresco.com/viewtopic.php?t=1908" rel="nofollow noopener noreferrer">http://forums.alfresco.com/viewtopic.php?t=1908</A><SPAN> about bad query performance. Hasn't there been done anything for this in 18 months. Is Alfresco ever going to commit to JCR or is it just marketing bullXXXX for managers that don't know better?</SPAN><BR /><BR /><SPAN>BTW Why isn't the JCR-JNDI bridge made part of official Alfresco release? There is no use for JCR API you can't get to from other apps running in same jvm but different webapp.</SPAN></BODY></HTML> Fri, 23 Nov 2007 11:55:38 GMT koivimik 2007-11-23T11:55:38Z Alfresco JCR xpath search https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144656#M101146 I've quite successfully used the Alfresco JCR-JNDI Bridge found in Jira. My problem is with QueryManager xpath query performance. It seems that no matter how simple query I make it always takes around 30 seconds to complete which is completely unacceptable. Here is a sample query //app:company_home/ Fri, 23 Nov 2007 11:55:38 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144656#M101146 koivimik 2007-11-23T11:55:38Z Re: Alfresco JCR xpath search https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144657#M101147 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>Some XPATH queries will be slow. The implementation walks the repo with some optimisations.</SPAN><BR /><BR /><SPAN>The example path query starts with // so will consider all nodes in the repo. There is no reason for // in the query. So you can remove it and it will be a lot faster.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Mon, 03 Dec 2007 11:29:48 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144657#M101147 andy 2007-12-03T11:29:48Z Re: Alfresco JCR xpath search https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144658#M101148 <HTML><HEAD></HEAD><BODY><SPAN>Hi Andy! </SPAN><BR /><BR /><SPAN>Thanks for replying. I've tried to use the query without // but it always results in 0 results. </SPAN><BR /><BR /><SPAN>Query app:company_home yields 1 result as does /app:company_home now if I query app:company_home/dws:Folder1 I get 0 results same with /app:company_home/dws:Folder1. It really doesn't matter what I put after app:company_home since I always get 0 results. Putting // before app:company_home always yields correct amount of results but the performance of the query is poor.</SPAN></BODY></HTML> Sun, 09 Dec 2007 11:25:04 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144658#M101148 koivimik 2007-12-09T11:25:04Z Re: Alfresco JCR xpath search https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144659#M101149 <HTML><HEAD></HEAD><BODY><SPAN>Are you sure your path is correct? As if you get 0 results it's probably not.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>Kevin</SPAN></BODY></HTML> Fri, 04 Jan 2008 16:13:14 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144659#M101149 kevinr 2008-01-04T16:13:14Z Re: Alfresco JCR xpath search https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144660#M101150 <HTML><HEAD></HEAD><BODY><SPAN>Well you tell me! I think it should be. If I have a folder called Folder1 with ns dws under the Company Home shouldn't the absolute path be /app:company_home/dws:Folder1 ?</SPAN></BODY></HTML> Sat, 05 Jan 2008 10:49:12 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144660#M101150 koivimik 2008-01-05T10:49:12Z Re: Alfresco JCR xpath search https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144661#M101151 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>This path is still relative against spaces.</SPAN><BR /><SPAN>Try to add prefix "/alf:space" instead of "//"</SPAN></BODY></HTML> Mon, 21 Jul 2008 17:33:14 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144661#M101151 szpakoo23 2008-07-21T17:33:14Z Re: Alfresco JCR xpath search https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144662#M101152 <HTML><HEAD></HEAD><BODY><SPAN>You might want to try vtd-xml for the best xml parsing/xpath performance</SPAN><BR /><BR /><A href="http://vtd-xml.sf.net" rel="nofollow noopener noreferrer">http://vtd-xml.sf.net</A></BODY></HTML> Thu, 26 Nov 2009 01:40:40 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-jcr-xpath-search/m-p/144662#M101152 jzhang2007 2009-11-26T01:40:40Z