[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