LogSat Software

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Thanks
jerbo128

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
jerbo128 Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 06 March 2006 Status: Offline Points: 178	Post Options Post Reply Quote jerbo128 Report Post Thanks(0) Quote Reply Topic: Different Count between tblMsgs and TblQuarantine 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 Thanks jerbo128

LogSat Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4106	Post Options Post Reply Quote LogSat Report Post Thanks(0) Quote Reply Posted: 05 November 2007 at 5:36pm
	jerbo128, 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 LogSat Software Spam Filter ISP

jerbo128 Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 06 March 2006 Status: Offline Points: 178	Post Options Post Reply Quote jerbo128 Report Post Thanks(0) Quote Reply Posted: 05 November 2007 at 7:05pm
	Thanks Roberto. I feel silly not thinking of that. Kudos to a great product!

LogSat Software

Site Navigation[Skip]

Spam Filter ISP Support Forum

Different Count between tblMsgs and TblQuarantine