Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-20607

subtree notification table misses an index

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Medium Medium
    • None
    • 4.7.0, 5.0, 2012.11, 2012.12, 2013.1
    • Database related
    • 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) ;

      Attachments

        Activity

          People

            Unassigned Unassigned
            a7ccb6eb-752c-4f73-908e-4baabf343cdd@accounts.ibexa.co Björn Dieding
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: