topic 'categories' crippling Alfresco performance in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/categories-crippling-alfresco-performance/m-p/161308#M115242 <HTML><HEAD></HEAD><BODY><SPAN>I'm running Alfresco Version: Community Network - v2.9.0 (B 683) on tomcat.</SPAN><BR /><BR /><SPAN>Whilst loading documents into a space with a custom presentation template, I found performance was being degraded.</SPAN><BR /><BR /><SPAN>Clicking on the space in Alfresco would cause Tomcat to run at 100% CPU and it could take 1 or two minutes (!) to display the space in question.</SPAN><BR /><SPAN>The more PDFs I added to the space, the worse things got, until finally you couldn't view the space at all - it would generate a TomCat proxy timeout error!</SPAN><BR /><BR /><SPAN>I found that by going into my presentation template and commenting out the lines which were displaying Categories, performance returned to normal.</SPAN><BR /><SPAN>Is this a known issue with catagories?</SPAN><BR /><SPAN>I found them very useful for tagging content with particular types of stuff, where a single metadata field would be inappropriate, as the document could fall in more than one category.</SPAN><BR /><BR /><SPAN>The culprit lines in the ftl file were:</SPAN><BR /><BR /><SPAN>&nbsp; &lt;td&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if child.properties["custom:CustomerFacing"]?exists&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ${child.properties["custom:CustomerFacing"]?string("Yes","No")}</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#else&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N/A</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/#if&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/td&gt;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#– &lt;@listSubCategories "Languages" child/&gt;–&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/td&gt;</SPAN><BR /><BR /><SPAN>&lt;td&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#–&lt;@listSubCategories "Product name" child/&gt;–&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/td&gt;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;td&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#–&nbsp; &lt;@listSubCategories "Product version" child/&gt;–&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/td&gt;</SPAN><BR /><SPAN>&lt;td&gt;</SPAN><BR /><SPAN>&lt;#–&lt;@listSubCategories "Product deployment type" child/&gt;–&gt;</SPAN><BR /><SPAN>&lt;/td&gt;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tr&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp; &lt;/#list&gt;</SPAN><BR /><SPAN>&lt;/table&gt;</SPAN><BR /><BR /><SPAN>&lt;#macro listSubCategories catName child&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;#list classification.getRootCategories("cm:generalclassifiable") as cat&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if cat.name = catName&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#assign first="yes"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#list cat.subCategories as subCat&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if subCat.immediateCategoryMembers?seq_contains(child)&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if first="no"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/#if&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ${subCat.name}</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#assign first="no"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/#if&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/#list&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/#if&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/#list&gt;</SPAN><BR /><SPAN>&lt;/#macro&gt;</SPAN><BR /><BR /><BR /><SPAN>Is there anything bad looking in there?</SPAN></BODY></HTML> Wed, 06 Aug 2008 12:15:34 GMT davidd 2008-08-06T12:15:34Z 'categories' crippling Alfresco performance https://connect.hyland.com/t5/alfresco-archive/categories-crippling-alfresco-performance/m-p/161308#M115242 I'm running Alfresco Version: Community Network - v2.9.0 (B 683) on tomcat.Whilst loading documents into a space with a custom presentation template, I found performance was being degraded.Clicking on the space in Alfresco would cause Tomcat to run at 100% CPU and it could take 1 or two minutes (!) Wed, 06 Aug 2008 12:15:34 GMT https://connect.hyland.com/t5/alfresco-archive/categories-crippling-alfresco-performance/m-p/161308#M115242 davidd 2008-08-06T12:15:34Z Re: 'categories' crippling Alfresco performance https://connect.hyland.com/t5/alfresco-archive/categories-crippling-alfresco-performance/m-p/161309#M115243 <HTML><HEAD></HEAD><BODY><SPAN>I do not really know about the templates you are using. But in case they use Lucene PATH queries, you might want to take a look at </SPAN><A href="http://wiki.alfresco.com/wiki/Search#Fields_in_the_index_and_how_they_are_exposed_for_queries" rel="nofollow noopener noreferrer">PARENT</A><SPAN> queries to find documents under a category. For me, this turned out to be much, much faster.</SPAN><BR /><BR /><SPAN>I have posted about this in French, see </SPAN><A href="http://forums.alfresco.com/fr/viewtopic.php?f=8&amp;t=1689&amp;p=7942" rel="nofollow noopener noreferrer">the French forum</A><SPAN>.</SPAN><BR /><BR /><SPAN>Hope this helps,</SPAN><BR /><SPAN>Kaspar</SPAN></BODY></HTML> Sun, 10 Aug 2008 10:55:24 GMT https://connect.hyland.com/t5/alfresco-archive/categories-crippling-alfresco-performance/m-p/161309#M115243 hbf 2008-08-10T10:55:24Z Re: 'categories' crippling Alfresco performance https://connect.hyland.com/t5/alfresco-archive/categories-crippling-alfresco-performance/m-p/161310#M115244 <HTML><HEAD></HEAD><BODY><SPAN>well the categories bits in templates I am using are just taken from the standard presentation templates in the Data Dictionary </SPAN><BR /><SPAN>that ships with ALfresco, and the examples in the ALfresco book by Munwar Sharrif.</SPAN><BR /><SPAN>My French is rather weak, but I will try and read your thread… <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></SPAN></BODY></HTML> Fri, 15 Aug 2008 08:31:28 GMT https://connect.hyland.com/t5/alfresco-archive/categories-crippling-alfresco-performance/m-p/161310#M115244 davidd 2008-08-15T08:31:28Z