Admin UI - manage groups page is too slow....
With Admin UI enabled the Manage Groups page takes 2 minutes+ to load even though we only have 900 groups
- it may be the attempt to pull in the count that makes it slow - I'm not sure its possible to do this in 1 query without it being slow though - I will dig a bit & see
explain SELECT `a`.`id` AS `id`, `a`.`title` AS `title`, `created_id_1`.`display_name` AS `created_id.display_name`, `a`.`description` AS `description`, `a`.`group_type` AS `group_type:label`, `a`.`visibility` AS `visibility:label`, COUNT(`Group_GroupContact_Contact_01`.`display_name`) AS `COUNT_Group_GroupContact_Contact_01_display_name`, `a`.`saved_search_id` AS `saved_search_id`, `a`.`is_active` AS `is_active`, `a`.`frontend_title` AS `frontend_title`, `a`.`name` AS `name`, `a`.`parents` AS `parents:label`
-> FROM civicrm_group a
-> LEFT JOIN (`civicrm_group_contact` `Group_GroupContact_Contact_01_via_groupcontact` INNER JOIN `civicrm_contact` `Group_GroupContact_Contact_01` ON (`Group_GroupContact_Contact_01_via_groupcontact`.`contact_id` = `Group_GroupContact_Contact_01`.`id`)) ON `Group_GroupContact_Contact_01_via_groupcontact`.`status` = "Added" AND `Group_GroupContact_Contact_01`.`is_deleted` = "0" AND `Group_GroupContact_Contact_01_via_groupcontact`.`group_id` = `a`.`id`
-> LEFT JOIN `civicrm_contact` `created_id_1` ON `a`.`created_id` = `created_id_1`.`id`
-> WHERE (`a`.`is_hidden` = "0")
-> GROUP BY `a`.`id`
-> ORDER BY `a`.`title` ASC
-> LIMIT 50
-> OFFSET 0;
+------+-------------+------------------------------------------------+--------+----------------------------------------------------+-----------------------------------+---------+-------------------------------------------------------------------+-------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+------------------------------------------------+--------+----------------------------------------------------+-----------------------------------+---------+-------------------------------------------------------------------+-------+----------------------------------------------+
| 1 | SIMPLE | a | index | NULL | PRIMARY | 4 | NULL | 907 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | Group_GroupContact_Contact_01_via_groupcontact | ref | UI_contact_group,FK_civicrm_group_contact_group_id | FK_civicrm_group_contact_group_id | 4 | civicrm.a.id | 32382 | Using where |
| 1 | SIMPLE | Group_GroupContact_Contact_01 | eq_ref | PRIMARY | PRIMARY | 4 | civicrm.Group_GroupContact_Contact_01_via_groupcontact.contact_id | 1 | Using where |
| 1 | SIMPLE | created_id_1 | eq_ref | PRIMARY | PRIMARY | 4 | civicrm.a.created_id | 1 | Using where |
+------+-------------+------------------------------------------------+--------+----------------------------------------------------+-----------------------------------+---------+-------------------------------------------------------------------+-------+----------------------------------------------+
4 rows in set (0.001 sec)
Edited by eileen