topic Lucene PATH wildcard query performance in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/lucene-path-wildcard-query-performance/m-p/249336#M202466 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm developing an application that will use Alfresco as a backend content repository.</SPAN><BR /><SPAN>I have a use case I'm implementing currently, where I would need to run frequent PATH wildcard queries</SPAN><BR /><SPAN>on the repository and I'm trying to figure out if this type of query will pose performance problems.</SPAN><BR /><BR /><SPAN>The PATH queries contain wildcards in the middle of the path and are of the form:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>PATH:"/app:company_home/cm:foo/cm:bar/*/*/cm:baz/*"<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>How does Alfresco implement queries of this form?</SPAN><BR /><BR /><SPAN>With Lucene query language this type of query is implemented using the Lucene</SPAN><BR /><SPAN>index but the index seems to only store information about the immediate parent of a node</SPAN><BR /><SPAN>(not ancestors or full path). Is this correct?</SPAN><BR /><SPAN>This seems to imply that the Alfresco query engine can't get the results using a simple</SPAN><BR /><SPAN>index search but needs to process each level of wildcards in the middle of the path separetely, right?</SPAN><BR /><BR /><SPAN>In our case the hierarchy levels in which the 2 wildcards in the middle appear would</SPAN><BR /><SPAN>contain a fairly large number of nodes (~1000 each).</SPAN><BR /><BR /><SPAN>I'm using Alfresco v3.3 and the Alfresco Web Service client API for running the queries.</SPAN></BODY></HTML> Thu, 04 Nov 2010 07:47:45 GMT aspa 2010-11-04T07:47:45Z Lucene PATH wildcard query performance https://connect.hyland.com/t5/alfresco-archive/lucene-path-wildcard-query-performance/m-p/249336#M202466 Hi,I'm developing an application that will use Alfresco as a backend content repository.I have a use case I'm implementing currently, where I would need to run frequent PATH wildcard querieson the repository and I'm trying to figure out if this type of query will pose performance problems.The PATH q Thu, 04 Nov 2010 07:47:45 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-path-wildcard-query-performance/m-p/249336#M202466 aspa 2010-11-04T07:47:45Z Re: Lucene PATH wildcard query performance https://connect.hyland.com/t5/alfresco-archive/lucene-path-wildcard-query-performance/m-p/249337#M202467 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>from my experience the PATH queries are rather slow and if you would have large repository. </SPAN><BR /><BR /><SPAN>To be sure try to generate many spaces and then try you search.</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><SPAN>smicyk</SPAN></BODY></HTML> Sat, 06 Nov 2010 19:30:14 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-path-wildcard-query-performance/m-p/249337#M202467 smicyk 2010-11-06T19:30:14Z