Review main Merged

26775[TASK] Add index to sys_category

Ingo Schmitt CR +2 V +2 Easy +3 −1 updated 01/13/14, 13:28

Commit message

All page, content and file-records TCEforms render a category 
tree in order to assign these. The tree building executes the 
same queries quite often. In order to optimize these queries
this change adds
* an index "category_parent" to sys_category.parent in order
  to for the parent category while index "parent" currently
  indexes the pid the record is stored.

* a combined index "category_list" to columns pid, deleted 
  and sys_language_uid.

Review

  • Code review CR +2

    Imported before Forger kept the single votes, the next import adds them.

  • Verified V +2

    Imported before Forger kept the single votes, the next import adds them.

Issues 1

Files 1