-- > From: Jo Rhett <[EMAIL PROTECTED]> > Date: Wed, 23 Jan 2008 13:12:12 -0800 > To: Amavis-Users <[email protected]> > Subject: [AMaViS-user] unify the wblist and mailaddr tables? > > So I'm working on making the amavisnewsql plugin work with the latest > tables. (patch coming) > > One of the changes that he made in the tables was to unify mailaddr > and wblist. So instead of > > # ' FROM wblist JOIN mailaddr ON wblist.sid=mailaddr.id'. > # ' WHERE wblist.rid=? AND mailaddr.email IN (%k)'. > # ' ORDER BY mailaddr.priority DESC'; > > It's just > > # ' FROM wblist ' WHERE wblist.rid=? AND wblist.email IN (%k)'. > # ' ORDER BY wblist.priority DESC';
Anything that would speed up SQL would be great. Keep in mind things like penpals and @. @domain.com [EMAIL PROTECTED] user@ and [EMAIL PROTECTED] lookups. Mark what do you think? Michael Scheidell, CTO >|SECNAP Network Security Winner 2008 Network Products Guide Hot Companies _________________________________________________________________________ This email has been scanned and certified safe by SpammerTrap(tm). For Information please see http://www.spammertrap.com _________________________________________________________________________ ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ 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/
