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

Use MySQL's built in "analyze" ("describe"? SQL statement to see what's taking so long). I'm betting on one server having an INDEX on the id or ex fields, and the other not. -- WARNING [EMAIL PROTECTED] address is an endangered species -- Use [EMAIL PROTECTED] Wanna help me out? Like Music? Bu

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]> &