topic Re: Poor performance of Browse Groups in Share in Alfresco Archive

Poor performance of Browse Groups in Share

vamirr — Thu, 22 Dec 2011 12:25:29 GMT

We've found an oddity with Browse Groups within the Share Admin Console. This is behavior is being exhibited under 3.4.The repository for the behavior described below has approximately 3000 users, 4000 groups, 800 sites and 1.5TB of data.When the admin user clicks on Browse groups, the resulting we

Re: Poor performance of Browse Groups in Share

jjengel11 — Thu, 05 Feb 2015 17:40:08 GMT

was there ever any resolution to this? i am having the exact same problem where this query takes over 4 minutes to run on my system. using percona 5.5 and then upgraded to 5.6. When I hint the query to use a specific index

LEFT OUTER JOIN ( alf_child_assoc a JOIN alf_child_assoc z2 USE INDEX (FK_ALF_CASS_CNODE) ON (z2.parent_node_id = 455 AND z2.child_node_id = a.parent_node_id )

it runs in under a second. is there any fix besides using the hint for this dynamically generated query .

I have about 350,000 rows in the alf_child_assoc table. when the query returns, I get ~ 11,400 results back

Re: Poor performance of Browse Groups in Share

mrogers — Thu, 05 Feb 2015 18:01:16 GMT

If it is still a problem in alfresco please make sure a JIRA is logged otherwise it will never get fixed. I've got a dim memory that this was fixed a few years ago.

Re: Poor performance of Browse Groups in Share

jjengel11 — Thu, 05 Feb 2015 20:36:22 GMT

thanks for the response. i will log a ticket. perhaps it is the version of alfresco that we are on that does not have the fix? i'll submit the ticket and see if they can tell me what version should have the fix.