• In general I agree with this article but there is one massive BUT that has been overlooked here and that is performance.

    I have a database where the design of the database with its referential integrity is such that any attempt to archive off old data means taking the server off-line for a day. Performance is totally unacceptable for deleting data.

    I am going to write up my findings on the performance issues with DRI so there is something quantitive rather than emotive to mull over