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


_______________________________________________
Visit http://www.mimedefang.org and http://www.canit.ca
MIMEDefang mailing list
[email protected]
http://lists.roaringpenguin.com/mailman/listinfo/mimedefang

Reply via email to