Print Page | Close Window

Advice on using spamfilter database using mysql

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6847
Printed Date: 16 December 2017 at 1:42pm


Topic: Advice on using spamfilter database using mysql
Posted By: morten44
Subject: Advice on using spamfilter database using mysql
Date Posted: 18 June 2010 at 6:06am
Hi
We are doing a 3rd attemt in using the build in database function to store spam mails using mysql
 
The 2 previous attemt has worked very well for the first 3-4 weeks and then it has just stopped working. everytime i activate the database the smapfilter freezes. I have waited for it in this freezing possision for 1 hour and nothing chances.
 
We have on a daily base about 200.000 spam mails and we want to keep them in the database for about 2 weeks before deleting itself. So we are talking 2-3million mails in the spam database at any time.
 
Would you expect this to work ok or will there be an issue with so big databases?
Is it better to try to go for SQL instead of Mysql (prefere to keep mysql if possible)
 
Before I start again, i just wanted to make sure I am not trying to implement something at is known to have problems
 
The server is a dedicated Win2003 Server that only works as Spamfilter  and Imail Server and will have the Mysql database installed on the same Server
 
Regards
Morten



Replies:
Posted By: AndrewD
Date Posted: 24 October 2010 at 11:15am
Hey Morten,
Did you end up getting this resolved?
Certainly MYSQL should have no issue handling the quantity.
 
Cheers


-------------
Spamfilter web interface. www.tyrexpg.com.au

See http://www.logsat.com/SpamFilter/Forums/forum_posts.asp?TID=6883



Print Page | Close Window