phpdevshell team mailing list archive

[Don Schoeman <924430@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: phpdevshell
     Importance: High
         Status: New


** Tags: index table

-- 
You received this bug notification because you are a member of
PHPDevShell, which is subscribed to PHPDevShell.
https://bugs.launchpad.net/bugs/924430

Title:
  Table indexing issue on pds_core_menu_structure

Status in Open Source PHP RAD Framework with UI.:
  New

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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/phpdevshell/+bug/924430/+subscriptions