Re: [PHP] Re: Left Join extremely slow (MySQL)

>"explain" >> >> Use MySQL's built in "analyze" ("describe"? SQL statement to see what's >> taking so long). The statement is called EXPLAIN. You can find it described here: http://www.mysql.com/doc/E/X/EXPLAIN.html >> I'm betting on one server having an INDEX on the id or ex fields, and the >>

Re: [PHP] Re: Left Join extremely slow (MySQL)

"explain" - - - - - - - - - - Scott Poarch www.globalhost.com - - - - - - - - - - > From: "Richard Lynch" <[EMAIL PROTECTED]> > Organization: Lynch Interplanetary Enterprises > Date: Fri, 3 Aug 2001 17:09:49 -0500 > To: <[EMAIL PROTECTED]> > Subject: [PHP] Re: Left Join extremely slow (MySQL