Add a record status flag to all entities and perform a soft delete for better performance and for keeping a change log for sync . Hard delete would only be performed by scheduled cleanup routines which will wipe the relations clean.
Log in to post a comment.