Details
-
Improvement
-
Resolution: Unresolved
-
Medium
-
None
-
4.7.0, 5.0, 2012.11, 2012.12, 2013.1
-
Mysql
Description
There is a slow query like this
select count(user_id) as count
from ezsubtree_notification_rule
where node_id = 648371
It can be resolved wiht the new index on
ALTER TABLE ezsubtree_notification_rule ADD INDEX `ezsubtree_notification_rule_node_id` (`node_id` ASC) ;