RE: FN-FORUM: Suggestions please

date posted 15th August 2003 16:06

- stored procedure that gets called once a day?
- do what you are doing, but set a datetime property in your datebase when
the task has been completed, then only run the cleanup if the datetime flag
> 1 day from current_date() (this is not a very neat solution, as the check
will be made at every login )

i would have thought the easiest solution will depend upon the RDBMS you are
using.

rather than deleting the data, it might make more sense to archive it off to
another table, that way if somebody says have you got the time sheets for
mrs miggins for 1987....


-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] Behalf Of PAMELA
WHITTAKER
Sent: 15 August 2003 16:16
To: FN-FORUM / [EMAIL REMOVED]
Subject: FN-FORUM: Suggestions please



Hi,
I am writing a timesheet at the moment and I want to make sure that
noting over 5 years old is kept on the database. The only way I can think of
is going through and deleting everything over five years old every time
someone logs in to the system which could be more than once a day.
especially on a Friday. Can anyone think of a way of only doing it once a
day please.

Thanks
Pam


'

NTMail K12 - the Mail Server for Education

==========
redmail.com - webmail with a difference!
10Mb for just GBP 9.99 a year. Launch special 1Gb for GBP 99.99 a year
IMAP, POP3, Spam Filtering and Anti Virus as standard.
Visit http://www.redmail.com/?fl-signup to join.

To advertise here: http://www.freelancers.net/advertising.html