Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.2.0, 4.3.0, 4.4.0, 4.5.0, 4.6.0
-
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.