Re: LEFT JOIN function locking up when using large database

Thank you very much! I am a first year software engineer so I'm still learning :-) I had a query that took 23 seconds, and now takes .01 sec. Thanks again! Rob Taft - Before posting, please check: http://www.mysq

LEFT JOIN function locking up when using large database

Any suggestions as to what the problem is? I tried this on both 3.23 and 4.0.7 and got the same results. The [EMAIL PROTECTED] would not take my email. Rob Taft [EMAIL PROTECTED] - Before posting, please check: http://www.mysq