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.
- 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.