speed of bayes (mysql)

[Jason Ede]

I've bayes running in mysql and after upgrading I ran it in debug mode to see what the times were like... Generally it was fine apart from the bayes check which took ages! (batch size was 10 messages)

08:52:10 [7768] dbg: bayes: database connection established
08:52:10 [7768] dbg: bayes: found bayes db version 3
08:52:10 [7768] dbg: bayes: Using userid: 5
08:53:56 [7768] dbg: bayes: seen (c21a23d9453de70a43644e737a49e81c47640d54 at sa_generated) put
08:53:56 [7768] dbg: bayes: learned 'c21a23d9453de70a43644e737a49e81c47640d54 at sa_generated', atime: 1213858923
08:53:56 [7768] dbg: learn: initializing learner
08:53:56 [7768] dbg: check: is spam? score=-3.598 required=5
08:53:56 [7768] dbg: check: tests=BAYES_00,HTML_MESSAGE,RCVD_IN_DNSWL_LOW

Any ideas on things I can check/investigate to speed this up?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.mailscanner.info/pipermail/mailscanner/attachments/20080619/2422c67d/attachment.html