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

Missing indexes on 3 tables

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Obsolete
    • Icon: Medium Medium
    • Customer request
    • 4.0.3, 4.1.0alpha2
    • Database related
    • None

    Description

      It's not a big issue but some index are mising on small tables:
      ezpolicy_limitation.policy_id
      ezworkflow_event index on (`version`,`workflow_id`)

      ezp generate this query:
      SELECT id, policy_id, identifier
      FROM ezpolicy_limitation
      WHERE policy_id='1208'
      ORDER BY id ASC;

      and
      SELECT id, placement
      FROM ezworkflow_event
      WHERE workflow_id='3' AND version='0'
      ORDER BY placement ASC
      LIMIT 2, 1;

      also missing on ezuser_accountkey.hash_key

      SELECT id, user_id, hash_key, time
      FROM ezuser_accountkey
      WHERE hash_key='52438d2fe681326422b56711d5f1b1f6';

      Attachments

        Activity

          People

            qwix qwix
            support.we@ez.no support.we@ez.no
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: