On Tue, Aug 12, 2008 at 04:13:57AM -0400, Michael Scheidell wrote: > > I don't think it will help to hack SA just for amavisd-new, and I don't > recommend it except for huge bayes databases (and then I don't know if it > will help too much)
So how huge is your database? It's hard to imagine so big that you'd need "special hacks". I have just 3 million tokens (~160MB of data) and few thousand users. It fits fine in my MySQL buffer. I even removed the atime index, since updating it is probably more costly than the unindexed 2 minute expire I run every night. Statistics said that 57% are 1-occurence tokens. I would interpret that as being mostly noise, probably I could even lower my token count. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
