Actually, it's exceedingly common with typical RDBMS that deletes are highly deleterious and time costly transactions to process die to locking database tables

Actually, it's exceedingly common with typical RDBMS that deletes are highly deleterious and time costly transactions to process die to locking database tables for a copious amount of time, bringing the system to a screeching halt. This is why general practice is to modify the the data in place and leave it there in an OLTP system.