Why does this sql cause MySQL 5 to hang?

2010-12-30 Thread Rick Faircloth
Hi, all and Happy New Year! (early...) I'm trying to run this query: select p.property_id, pl.propertyPhotoLink, o.office_name from properties p left join hmls_property_photo_links pl on

Re: Why does this sql cause MySQL 5 to hang?

2010-12-30 Thread Russ Michaels
Rick, give this handy tool a try, it is rather good. http://www.jetprofiler.com/ http://www.jetprofiler.com/Russ On Fri, Dec 31, 2010 at 1:11 AM, Rick Faircloth r...@whitestonemedia.comwrote: Hi, all and Happy New Year! (early...) I'm trying to run this query: select p.property_id,

RE: Why does this sql cause MySQL 5 to hang?

2010-12-30 Thread Rick Faircloth
does this sql cause MySQL 5 to hang? Rick, give this handy tool a try, it is rather good. http://www.jetprofiler.com/ http://www.jetprofiler.com/Russ On Fri, Dec 31, 2010 at 1:11 AM, Rick Faircloth r...@whitestonemedia.comwrote: Hi, all and Happy New Year! (early...) I'm trying to run

RE: Why does this sql cause MySQL 5 to hang?

2010-12-30 Thread Rick Faircloth
...@whitestonemedia.com] Sent: Thursday, December 30, 2010 9:42 PM To: cf-talk Subject: RE: Why does this sql cause MySQL 5 to hang? Interesting tool, Russ... thanks for the tip. Unfortunately, it didn't recognize my query as a Select, so it couldn't provide any insight. Rick -Original Message