Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Medium Medium
    • Resolution: Unresolved
    • Affects Version/s: 4.7.0, 5.0, 2012.11, 2012.12, 2013.1
    • Fix Version/s: None
    • Component/s: Database related
    • Labels:
    • Environment:

      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) ;

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Björn Dieding@xrow.de
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: