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

Temporary table created in eZContentObjectTreeNode::createPermissionCheckingSQL() slows sites with many members

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • None
    • 4.2.0
    • Database related
    • None

    Description

      The temporary table created in eZContentObjectTreeNode::createPermissionCheckingSQL() has not indexes in eZ Publish 4.2.

      If the changes introduced to this table, in eZ Publish 4.3, were backported to 4.2, this performance constraint would be solved.

      Steps to reproduce
      • Login, as a regular member, to a site with many members. Browse through the site and monitor the time consumed to generate the temporary table ezgroup_perm_tmp_%
      • Create a few more users into the same group
      • Review the time consumed to generate the table
      • It should take longer and consume more space in temp

      Attachments

        Activity

          People

            e8318ba6-e4ae-477c-9116-36c073bd11a3@accounts.ibexa.co Patrick Allaert
            joc@ez.no joc@ez.no
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: