Wes wrote:
On 11/29/07 2:23 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
But to get hold of the timeout problems and the bad performing bayes db we
did what the spamassassin people suggest since quite some time:
- use global bayes instead bayes per user
- do not use auto_expire in local.cf
- run instead a cronjob once a day that expires old tokens
This is what I have configured, except with DBM instead of SQL (next on my
agenda), and expire every 3 hours to keep the DB from getting out of hand.
Do not waste any more time trying to get more performance out of DBM.
Just about any SQL based database will perform a lot better than DBM
will when your bayes database is large.
If you process a lot of mail and are using autolearn you are going to
have a large bayes database, period. If the database isn't large enough
it is going to churn so fast that it'll defeat the purpose of even
having a bayes database.
Daryl
