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

limitation on Group in createPermissionCheckingSQL is very slow in sites with populated groups

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 4.2.0, 4.3.0, 4.4.0, 4.5.0, 4.6.0
    • Fix Version/s: Customer request, 5.1
    • Component/s: Database related
    • Labels:
      None

      Description

      Fetching nodes with eZContentObjectTreeNode::subTreeByNodeID on a site with a policy with *Group (self )* takes a long time to execute when there is a large number of users within the user's group.

      The query resulting from createPermissionCheckingSQL could be enhanced to perform better in this scenario.

      Steps to reproduce
      • Create a large number of users within group //Members//
      • Create a policy that includes a test for *Group ( self )*
      • Create a view that executes eZContentObjectTreeNode::subTreeByNodeID so that you can call it from the admin interface logged in as a member
      • Check how much it takes for the fetch function to produce results.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                joc@ez.no J. J. Cavalleri
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days, 7 hours, 55 minutes
                  2d 7h 55m