[thelist] Setting records to expire after a specific time?

David Kutcher david_kutcher at hotmail.com
Wed Feb 27 14:19:01 CST 2002

That all depends on the database.

If you're using one that allows stored procedures, use that.

If not, you'll have to figure out a creative means of doing it (like if
using MySQL).

Then again, just because they've expired, doesn't mean you should
necessarily delete them.  Possibly pitch the client on "archiving" them or
adding a time clause in your queries.  I've often find that when you explain
ways to the client of hiding old data (maybe a job that that is older than
30 days or something like that) without deleting it, they're happier.


More information about the thelist mailing list