Brian Wong wrote:
If you just delete records from the 'quarantine' table there would be
no problem. Because the reference is to the 'msgs' table, not the
other way around.
if you then 'clean out logs' (ie, delete records from msgs table every
90 days) won't it be missing a key and mess up
On 7/5/07, Michael Scheidell [EMAIL PROTECTED] wrote:
In SQL based quarantine, if I run a script to delete quarantined email
after (x) days, but want to keep the LOG entries, what is best to do?
Just find quarantined chunks and set to ''? Or point id to a phony
(blank) record?
The former
In SQL based quarantine, if I run a script to delete quarantined email
after (x) days, but want to keep the LOG entries, what is best to do?
Just find quarantined chunks and set to ''? Or point id to a phony
(blank) record?
The former would keep lots of records that are duplicates (blank chunks)
Brian Wong wrote:
On 7/5/07, Michael Scheidell [EMAIL PROTECTED] wrote:
Brian Wong wrote:
If you just delete records from the 'quarantine' table there would be
no problem. Because the reference is to the 'msgs' table, not the
other way around.
if you then 'clean out logs' (ie, delete
On 7/5/07, Michael Scheidell [EMAIL PROTECTED] wrote:
Brian Wong wrote:
If you just delete records from the 'quarantine' table there would be
no problem. Because the reference is to the 'msgs' table, not the
other way around.
if you then 'clean out logs' (ie, delete records from msgs
