topic Overall system feels sluggish in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/overall-system-feels-sluggish/m-p/144852#M101267 <HTML><HEAD></HEAD><BODY><SPAN>Hello, </SPAN><BR /><BR /><SPAN>I am running Alfresco 1.4 with a lot of content and overall it feel very sluggish. The server is a 2 cpu 1.5ghz Power PC with 1.5GB ram. </SPAN><BR /><BR /><SPAN>Query results:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>select parent_node_id, count(child_node_id) children from child_assoc group by parent_node_id order by children desc limit 10;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><PRE class="language-none line-numbers"><CODE>+—————-+———-+<BR />| parent_node_id | children |<BR />+—————-+———-+<BR />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26 |&nbsp;&nbsp;&nbsp;&nbsp; 5707 | <BR />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25 |&nbsp;&nbsp;&nbsp;&nbsp; 1068 | <BR />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 176 | <BR />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4892 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 57 | <BR />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 752 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 37 | <BR />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35 | <BR />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 768 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28 | <BR />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 856 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25 | <BR />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 280 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24 | <BR />|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 378 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19 | <BR />+—————-+———-+<BR />10 rows in set (0.35 sec)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Any ideas?</SPAN></BODY></HTML> Fri, 07 Sep 2007 07:46:43 GMT steel 2007-09-07T07:46:43Z Overall system feels sluggish https://connect.hyland.com/t5/alfresco-archive/overall-system-feels-sluggish/m-p/144852#M101267 Hello, I am running Alfresco 1.4 with a lot of content and overall it feel very sluggish. The server is a 2 cpu 1.5ghz Power PC with 1.5GB ram. Query results:select parent_node_id, count(child_node_id) children from child_assoc group by parent_node_id order by children desc limit 10;‍+—————-+———-+| Fri, 07 Sep 2007 07:46:43 GMT https://connect.hyland.com/t5/alfresco-archive/overall-system-feels-sluggish/m-p/144852#M101267 steel 2007-09-07T07:46:43Z Re: Overall system feels sluggish https://connect.hyland.com/t5/alfresco-archive/overall-system-feels-sluggish/m-p/144853#M101268 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>Can you be more specifc about the exact repo version.</SPAN><BR /><BR /><SPAN>Is there some specific use case you can describe?</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Tue, 11 Sep 2007 09:01:06 GMT https://connect.hyland.com/t5/alfresco-archive/overall-system-feels-sluggish/m-p/144853#M101268 andy 2007-09-11T09:01:06Z