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;
+—————-+———-+
| parent_node_id | children |
+—————-+———-+
| 26 | 5707 |
| 25 | 1068 |
| 16 | 176 |
| 4892 | 57 |
| 752 | 37 |
| 20 | 35 |
| 768 | 28 |
| 856 | 25 |
| 280 | 24 |
| 378 | 19 |
+—————-+———-+
10 rows in set (0.35 sec)
Any ideas?