topic Freemarker search performance in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/freemarker-search-performance/m-p/72748#M47345 <HTML><HEAD></HEAD><BODY><SPAN>There are multiple ways to find documents or list a directory in a FreeMarker template:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>&lt;#list companyhome.childByNamePath["Data Dictionary/Presentation Templates"].children as child&gt;<BR />&lt;#list companyhome.childrenByXPath["*[@cm:name='Data Dictionary']/*[@cm:name='Space Templates']/*[@cm:name='Software Engineering Project']/*"] as child&gt;<BR />&lt;#list companyhome.childrenByLuceneSearch["TEXT:alfresco"] as child&gt;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>Are there important differences concerning the search performance?</SPAN><BR /><BR /><SPAN>Secondly I'm looking for a way to see if a folder contains documents in a FreeMarker template. Looping over all the documents and counting them to see if there are any seems silly and eats all my processing power.&nbsp; Is there some better, more performant method to do this?</SPAN></BODY></HTML> Thu, 16 Nov 2006 15:59:43 GMT simon 2006-11-16T15:59:43Z Freemarker search performance https://connect.hyland.com/t5/alfresco-archive/freemarker-search-performance/m-p/72748#M47345 There are multiple ways to find documents or list a directory in a FreeMarker template:&lt;#list companyhome.childByNamePath["Data Dictionary/Presentation Templates"].children as child&gt;&lt;#list companyhome.childrenByXPath["*[@cm:name='Data Dictionary']/*[@cm:name='Space Templates']/*[@cm:name='S Thu, 16 Nov 2006 15:59:43 GMT https://connect.hyland.com/t5/alfresco-archive/freemarker-search-performance/m-p/72748#M47345 simon 2006-11-16T15:59:43Z Re: Freemarker search performance https://connect.hyland.com/t5/alfresco-archive/freemarker-search-performance/m-p/72749#M47346 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>In general, lucene based queries will be faster but they do not support full XPATH like predicates etc. The XPath implementation uses saxon and a model built on top of the node service. I would prefer lucene and use xpath when this is not possible, or when I know the set is well constrained - ie will not consider all nodes in the repo ….)</SPAN><BR /><BR /><SPAN>You could try folder.children.size&nbsp;&nbsp; or do you want to exclude folders?</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Wed, 29 Nov 2006 12:28:24 GMT https://connect.hyland.com/t5/alfresco-archive/freemarker-search-performance/m-p/72749#M47346 andy 2006-11-29T12:28:24Z