Re: Checkboxes to gather rows to delete
| From: | Jason Wong | Date: | Mon, 24 Feb 2003 17:04:52 +0000 |
| Subject: | Re: Checkboxes to gather rows to delete | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25879@lists.php.net to get a copy of this message | ||
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
*/