Black/whitelists via SQL lookup

[Ken Anderson (Pacific Internet)]

Hi,

We process about 600k msgs across 2 machines, and use per user rules in
CustomConfig.pm. We store the per user rules in mySQL, but push them out
via a perl script to mailscanner rules directories that MailScanner
reads when it starts up.

MailScanner loads and stores them all in memory and this increases the
startup time as it reads the rules, and the RAM requirements of each
MailScanner child process, but once they are in memory, it doesn't
matter where they came from (sql or flat file).

I can't address the scalability of this though, since we only have about
500 custom per user rules right now.

Ken Anderson
Pacific.Net


ISP List wrote:

> Is anyone using the CustomConfig.pm module written by Oliver Pitzeier to do
> black/whitelist lookups via SQL on a per-user basis?  If so, can you
> comment on the performance impact?  We currently process about 1 million
> messages a day across 4 servers.
>
> Julian -- have you considered adding Oliver's code to the default
> CustomConfig.pm?  It sure would be nice from an upgrade perspective (not
> having to re-add the code after each update).
>
> ---------------------------------------
> Mike Bacher / mike at sparklogic.com
> SparkLogic Development / ISP Consulting
> Use OptiGold ISP? Check out OptiSkin!
> http://www.sparklogic.com/optiskin/
> ---------------------------------------
>
>