> > Rather than deleting a record, flag it as "inactive" and > > adjust other queries only to look in records flagged as > > "active". This is nice because if someone screws up, you > > can roll it back. > > This feature was standard in dBase, Clipper, Foxpro and al. > I wonder why is has not been kept in more modern databases > and SQL.
While "soft deletes" can be very nice, they can also have significant performance ramifications. Modern databases do exactly what you tell them to do, for very good reasons, and it's easy enough to write "soft delete" functionality if you want or need it. It typically doesn't scale especially well, though, if you have volatile records. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
