Print Page | Close Window

Different Count between tblMsgs and TblQuarantine

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
Printed Date: 25 September 2018 at 3:29am

Topic: Different Count between tblMsgs and TblQuarantine
Posted By: jerbo128
Subject: Different Count between tblMsgs and TblQuarantine
Date Posted: 04 November 2007 at 9:21pm

When I look at the count of tblMsgs and tblQuarantine, their count differs.

tblquarantine -  528K
tblMsgs - 410K
I delete expired emails and check for orphans every 5 minutes with these queries:
DELETE FROM tblQuarantine WHERE tblQuarantine.Expire <> 0
DELETE tblMsgs FROM tblMsgs LEFT JOIN tblQuarantine
ON tblMsgs.MsgID = tblQuarantine.MsgID WHERE (tblQuarantine.MsgID IS NULL)
DELETE tblQuarantine FROM tblQuarantine LEFT JOIN tblMsgs
ON tblQuarantine.MsgID = tblMsgs.MsgID WHERE (tblMsgs.MsgID IS NULL)
Anybody - Any ideas as to why they could be so different?  What else can a guy do to correct this?
Running SFE .728 with MSSQL

Posted By: LogSat
Date Posted: 05 November 2007 at 5:36pm

If an email arrives with multiple recipients and is quarantined, SpamFilter will only store one record for the actual contents of the email in the tblMsgs table. Then individual records are added for every recipient in the tblQuarantine table containing just the specific recipient data, and all these records point to the one single record containing the binary email text. It's thus normal that there are more entries in the tblQuarantine.

Roberto Franceschetti" rel="nofollow - LogSat Software" rel="nofollow - Spam Filter ISP

Posted By: jerbo128
Date Posted: 05 November 2007 at 7:05pm
Embarrassed   Thanks Roberto.  I feel silly not thinking of that.
Kudos to a great product!

Print Page | Close Window