Mike Jackson wrote:
On my personal server, I'm running SA 3.0.4 with the user prefs, Bayes,
and AWL in a MySQL database (mostly because it would be "cooler" that
way). On my employer's server, I'm running the same SA version, but with
file-based DBs and user prefs. We're going to be rolling out doing
filtering for all our mailboxes (several hundred) as opposed to opt-in
(as we're doing it now on about 20 accounts). I know I could do
benchmarks myself, but I wanted to get your impressions if there's a
performance improvement using SQL for storage (user prefs, Bayes, AWL)
rather than files. Thanks.
SQL simply doesnt scale very well for bayes. We have a serverfarm of
12 spamassassin servers and storing bayes in SQL. We see on average
about 4000 queries per second. The MySQL server has been optimized
to hell and back and is running on high-end hardware,but just simply
doesnt scale as more and more mail begins to roll in.
Cami
