How to apply soft-delete for a node deletion?

[okaprinarjaya]

Hi,

I need to apply soft-delete when doing a node deletion. I will use an extra field named: deleted with its value 1 char Y for the row is soft-deleted and 1 char N forr the row is not soft-deleted.

I don't want to hard delete using real SQL DELETE command. because hard / real DELETE will make worst performance in database.

Please Enligthenment

Thank you