>> 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';
On Jan 29, 2008, at 11:35 AM, Michael Scheidell wrote: > Anything that would speed up SQL would be great. Pretty much my thought. > Keep in mind things like penpals and @. @domain.com [EMAIL PROTECTED] > user@ > and [EMAIL PROTECTED] lookups. In looking at the code, I think these are synonymous. There's no difference, really. > Mark what do you think? I'm wondering if Mark is out of town, he's been fairly quiet on the list of late. -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness ------------------------------------------------------------------------- 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 AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/