HowtoForge: Optimizing DSPAM + MySQL 4.1
Apr 20, 2006, 08:30 (0 Talkback[s])
[ Thanks to Falko
Timme for this link. ]
"DSPAM is a scalable and open-source content-based spam filter
designed for multi-user enterprise systems. It's great at filtering
out spam but on busy mailservers the pruning of the MySQL databases
takes way too long time...
"The default purge-4.1.sql script provided with DSPAM can be
heavily optimized by adding indexes to the database and using the
indexes properly when pruning..."