Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Different Count between tblMsgs and TblQuarantine
  FAQ FAQ  Forum Search   Register Register  Login Login

Different Count between tblMsgs and TblQuarantine

 Post Reply Post Reply
Author
jerbo128 View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 March 2006
Status: Offline
Points: 178
Post Options Post Options   Thanks (0) Thanks(0)   Quote jerbo128 Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
jerbo128 View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 March 2006
Status: Offline
Points: 178
Post Options Post Options   Thanks (0) Thanks(0)   Quote jerbo128 Quote  Post ReplyReply Direct Link To This Post Posted: 05 November 2007 at 7:05pm
Embarrassed   Thanks Roberto.  I feel silly not thinking of that.
 
Kudos to a great product!
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.047 seconds.