CiviCRM Community Forums (archive)

We have several sites using a multisite & it's clear that there are some performance issues to be ironed out. We'd like to get some momentum towards fixing them but need some help pinning them down & prioritising them. Potentially we'd also like to set up a mailing list to try to build communication with interested groups.

Multilevel permissioning (multisite module) uses in built CiviCRM functionality but it uses some areas intensively & is affected by inefficiencies relating to them. The ones on my radar in order or perceived importance.

1) Hierarchical groups & their interaction with smart groups - I'm convinced we need to create an option whereby a smart group can be constrained by it's parent group. At the moment I'm seeing the group_contact_cache table create hundreds of thousands of records when people create a smart group that appears to them to only contain a few hundred. When people who have greater permissions view the group they are frustrated that they cannot see what the others are seeing (which is when they start creating circular groups).

2 ACL caching Various fixes made to the contact caching code over time have not been made to ACL caching. Deadlocks in on the ACL cache table are seen in the logs. I suspect this is when other ACLs -e.g custom data - are also in place

3 large numbers of groups - we seem to get large numbers of groups so in the advanced search we are seeing many queries to get the group names (e.g. 100 individual queries rather than 1 query which is subsequently cached)

4 contact summary problem
- possibly fixed but there was a performance issue loaded the contact summary due to all smart groups being resolved (http://forum.civicrm.org/index.php/topic,21775.msg91193.html#msg91193)

And Bugs

• A bug - contact search counts are often wrong http://forum.civicrm.org/index.php/topic,22815.msg99245.html#msg99245
• in 3.4 (unsure about more recently) if a person saves a contact who is in a group they don't have permission to the contact is removed from that group