Details
-
Bug
-
Resolution: Fixed
-
Medium
-
5.2
-
None
Description
Please optimize the eZXMLTextType::deleteStoredObjectAttribute function. That function features the following query:
SELECT DISTINCT id FROM ezurl LEFT JOIN ezurl_object_link ON (ezurl.id = ezurl_object_link.url_id) WHERE url_id IS NULL
This query is executed for every ezxmltype attribute for every version of the objects:
eZContentObject::purge: ... foreach ( $contentobjectAttributes as $contentobjectAttribute ) { $dataType = $contentobjectAttribute->dataType(); if ( !$dataType ) continue; $dataType->deleteStoredObjectAttribute( $contentobjectAttribute ); } $attrOffset += $attrLimit; ...
This should be optimized, to prevent timeouts derived from deleting just a few contents.