topic Re: Alfresco JCR xpath search in Alfresco Archive 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 andy 2007-12-03T11:29:48Z 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