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
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6286
Printed Date: 16 January 2026 at 2:00pm
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 - 528KtblMsgs - 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
|
Replies:
Posted By: LogSat
Date 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 http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Posted By: jerbo128
Date Posted: 05 November 2007 at 7:05pm
 Thanks Roberto. I feel silly not thinking of that.
Kudos to a great product!
|