Table indexing issue on pds_core_menu_structure

Bug #924430 reported by Don Schoeman on 2012-01-31
This bug affects 1 person
Affects Status Importance Assigned to Milestone

Bug Description

An SQL join is performed between the "table pds_core_menu_structure" and "pds_core_menu_items" when the menu array is being built. The two tables are joined using their respective menu_id fields. However, the menu_id field in pds_core_menu_structure is not indexed at all and this may have a slight performance impact on a busy site with a lot of first-hit/non-cached queries and a lot of menus.

I therefore suggest that a unique index (if possible) is placed on the menu_id field of pds_core_menu_structure. It will speed up the join request quite nicely.

This issue most probably exists in all versions of PHPDevShell.

Changed in phpdevshell:
assignee: nobody → TitanKing (titan-phpdevshell)
status: New → Fix Committed
Changed in phpdevshell:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers