Optimizing DSPAM + MySQL 4.1
DSPAM is a scalable and open-source content-based spam filter designed for multi-user enterprise systems. It is great at filtering out spam but on busy mailservers the pruning of the MySQL databases takes way too much 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.
(Submitted by Falko Timme Tue May 9, 2006 )
Our content can be syndicated: Main page Mac Page
Copyright 1999-2005 Noel Davis. Noel also runs web sites about sailing and kayaking.
All trademarks are the property of their owners.
All articles are owned by their author