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

Add index to ezcobj_state_link

    XMLWordPrintable

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

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            Filipe.Dobreira@ez.no Filipe Dobreira (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: