Paolo, > As expected, there was no significant speedup/slowdown.
Ok, thanks for your investigation. > You might want to add a note for MySQL users to read Chapter 15 of the > reference manual.... On chapter 15.17 I found: >... > So, do not waste time and resources by creating a specific index on > quarantine.mail_id since it doesn't speedup COUNT(*) queries, which are > anyway meaningless without a WHERE chunk_ind=1 clause. Thanks, will add a note to README.sql (already on the web page now). Mark ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ 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/
