On Monday 24 February 2003 23:57, George Pitcher wrote: > Can I raise a point of principle here. > > My databases never have records deleted - instead they are marked as being > deleted in a status field. That way, they are always there for reference. > > Unless you are running a system that needs the space or has extremely high > turnover of deleted records, this makes sesne. Better still, setup parallel tables and move deleted records over. That way you'll save cluttering up the main tables. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* A diplomat's life consists of three things: protocol, Geritol, and alcohol. -- Adlai Stevenson */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
