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.