Inefficient procedure ecfVersion_DeleteByObjectIds
Sep 26, 2017
Oct 06, 2017
Closed, Fixed and tested
The procedure ecfVersion_DeleteByObjectIds may perform poorly in some scenarios.
- Loads affected classes (MetaObjectId, MetaClassId and WorkId).
- Inserts them into a temp table.
- Uses a cursor to iterate through that.
- Passes the rows one by one to mdpsp_sys_DeleteMetaKeyObjects, which loads the MetaKey and deletes it.
This is hugely inefficient. It should be handled by set processing.