for the archive: > 'sel_penpals' => # no message-id references list > "SELECT msgs.time_num, msgs.mail_id, subject". > " FROM msgs JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id". > " WHERE sid=? AND rid=? AND content!='V' AND ds='P'". > " ORDER BY msgs.time_num DESC LIMIT 1", > > manual testing showed some very strange behaviour (so I suspect > something happened to mysql install). I rebuild (create table new from > old; insert into new select * from old; rename old to delete,new to > old;drop table table delete) on msgs qnd msgrcpt; > no foreign keys, using innodb, VERY LIGHT ACTIVITY ON HOST. > > above query takes 60 seconds. > even twice (after letting cache settle in). > > I took the 'limit 1' off, and its less then 1 second.
Removed 'LIMIT 1' in 2.6.2. Mark ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ 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/
