21 Jul
2006
21 Jul
'06
9:38 a.m.
On 21 Jul 2006, at 04:07, Larry Garfield wrote:
Adding a "Deleted" column to node, comment, and various other tables means that every query against those tables would have to be modified to add "WHERE deleted=0". Between core and contrib, that's thousands of queries that would need to be updated.
Adding an extra where-clause to all queries is perfectly valid if that is the best solution from a technical point of view. We shouldn't go with a solution that is sub-optimal, and avoid a superior solution just because it is a lot of work. That sort of decisions tend to backfire in the long run. -- Dries Buytaert :: http://www.buytaert.net/