Details

      Description

      In situations where the ezcobj_state_link table grows to a large amount of entries, it would be beneficial (performance-wise) to have an index.

      Proposed improvement:

      ALTER TABLE x.`ezcobj_state_link` ADD INDEX `state_idx` (`contentobject_state_id` ASC), ADD INDEX `state_obj_idx` (`contentobject_state_id` ASC, `contentobject_id` ASC);
      

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Filipe Dobreira (Inactive)
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated: