> I've noticed that MailZu now takes very very long to execute it's > queries. I believe this to be because the maddr table no longer has > an index on the email column. Would adding that index in there as a > non-unique really fubar anything? > I don't think so. What engine are you using in MySQL for the table maddr? InnoDB or MYISAM?
> Adding in "WHERE parition_tag = 0" to the queries within MailZu would > probably solve the issue; however, that'll break as soon as partition_tag > != 0. > > I have a similar issue on a home written script to get count of > quarantined messages for user: > SELECT count(*) AS count FROM amavisd_stats.maddr, > amavisd_stats.msgrcpt, amavisd_stats.msgs > where msgs.quar_type = 'Q' > and msgrcpt.rs != 'R' > and msgrcpt.rs != 'D' > and msgs.mail_id = msgrcpt.mail_id > and msgrcpt.rid = maddr.id > and maddr.email = '$email' > > My query is very slow now after changing the unique key on > maddr. I've added "where partition_tag = 0" and that speeds it up to > where it used to be; however, as soon as i tell amavisd-new to write > a partition_tag other than 0, things are no doubt going to blow up. > > - Nate > // SteveB -- GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen! Jetzt dabei sein: http://www.shortview.de/[EMAIL PROTECTED] ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ 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/
