Details
-
Improvement
-
Resolution: Unresolved
-
High
-
4.5.0
-
N/A
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);