Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Cool MS SQL Mod!
  FAQ FAQ  Forum Search   Register Register  Login Login

Cool MS SQL Mod!

 Post Reply Post Reply
Author
TechSquared View Drop Down
Newbie
Newbie


Joined: 01 March 2006
Location: United States
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote TechSquared Quote  Post ReplyReply Direct Link To This Post Topic: Cool MS SQL Mod!
    Posted: 01 March 2006 at 9:21am

One of the problems I faced while putting this in place for multiple domains is the issue of all the non-existent emails addresses that were getting SPAM.  I talked to a MS SQL expert and designed a trigger that does the following.

When the SpamFilter software creates an entry in the database, the trigger fires (on any insert) and queries the Login table.  If the incoming email is not in the Login table (which means they are checking the quarantine) the record is updated as if the user looked at the piece of mail through the web interface and deleted it.  The next purge that SpamFilter runs clears the entry from the database.

This keeps me from having a huge database of emails that are held (in my case 10 days) for email addresses that do not exist.

I would be interested in thoughts on how this affects the Bayesian Analysis.

Please let me know if you are interested in this Code.

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: 01 March 2006 at 4:28pm
That's one we're "envious" we did not think about ourselves! 

Excellent idea!

There won't be any effect on the Bayesian filter, as the database is not used by the process that "learns" new incoming emails.


Edited by LogSat
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.078 seconds.