SA3.0 Bayes SQL db size

[Ryan Moore <ry...@perigee.net>]

Just have a question regarding storing Bayes in SQL with Spamassassin 
3.0. I already converted the old dbm files and such, everything is 
working good, question I have is performance and token count. Previously 
I had set the max db size to 250000 tokens via the 
bayes_expiry_max_db_size config option in my local.cf.

I had put a new server online last week and forgot to uncomment 
'sa-learn --force-expire' in the crontab, so the db grew to 900000 
tokens. Things still seemed to run quite smooth however, and I'm 
guessing that SQL lets you have a much larger db without the performance 
loss, just curious what other people in the same setup are using as a 
max db size. This server doesn't process that much stuff, 100-150k 
messages a week perhaps.


-- 

Ryan Moore
----------
Perigee.net Corporation
704-849-8355 (sales)
704-849-8017 (tech)
www.perigee.net