> Goog evening Jari, > > Am 2009-07-04 13:46:45, schrieb Jari Fredriksson: >> http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeAwl > > Thankyou for the link, but if I understand it right, spamassassin is > then using ONE Database/Table for ALL users... This mean, the Database > will grow more then 10.000 ROW's a day... > > Is in spamassassin something like an autoexpire? >
You can add to the awl table a timeupdated field with properties "default current_timestamp on update current_timestamp" at least in MySQL. And cron the autoexpire with it. > Most spams I get are with UNIQUE From: header. I allready collect this > infos using procmail recipes... And since 2002 I have collectedt over > 27 million different E-Mails > 100-200 megabytes data, which your current awl-database must contain already. No big deal for an rdbms?
