We have noticed that in our Production server BOM row deletion is super-slow (3-4 minutes per row) and that multiple row deletion is timed out. Which also causes the overall system to give timeouts (XML messaging, login etc.) So basically using multiple row deletion effectively kills the system for some time.
I've trace the error back to WIP database where is generates quite many parallel queries. And most of them are suspended until this major query finishes.
(@P0 nvarchar(4000))SELECT COUNT(BOM_COMPONENT_GBO) ROW_COUNT FROM SFC_ASSY WHERE BOM_COMPONENT_GBO=@P0
Since our SFC_ASSY tabel is huge (18,6M rows) it takes forever.
Is there anything to be done to make the BOM deletion faster?
If not - can I delete the rows manually from DB? Which tables are affected?