[Mimedefang] Atime Index for SQL implementations of Bayes

Kevin A. McGrail kmcgrail at pccc.com
Fri May 20 10:01:16 EDT 2005


Just a quick note that while I was looking through the SQL Bayes
Implementation for mysql for SpamAssassin 3.0.2, I noticed that atime was
used in the expiry runs but wasn't indexed.

I submitted a patch and opened a bug report and thanks to parkerm, got even
a better index patch than I submitted.

Therefore, if you are using SQL Bayes, recommend you add an index as follows
(mySQL syntax) :

alter table bayes_token add INDEX bayes_token_idx2 (id, atime);

Regards,
KAM





More information about the MIMEDefang mailing list