Details
-
Improvement
-
Resolution: Obsolete
-
Medium
-
4.0.1
-
None
Description
... in eZContentObjectTreeNode::createPermissionCheckingSQL().
Creating temporary tables consumes quite some time.
Can be done with 1 additonal table and IN():
FROM ... ezcontentobject_tree owner_cobjt ...
WHERE
... ezcontentobject.owner_id=owner_cobjt.contentobject_id
AND
owner_cobjt.parent_node_id IN (" implode( ', ', $parentList ) ")
or with 2 additional tables:
FROM ... ezcontentobject_tree owner_cobjt, ezcontentobject_tree current_user_cobjt ...
WHERE
... ezcontentobject.owner_id=owner_cobjt.contentobject_id
AND
owner_cobjt.parent_node_id = current_user_cobjt.parent_node_id AND
current_user_cobjt.contentobject_id=" . $currentUserID . "
Attachments
Issue Links
- relates to
-
EZP-13948 Temporary tables for permission checking should be reused during 1 page request
- Closed