Has anyone found a problem (and solution) on LEFT JOIN when
using MySQL version 3.23.39 under SuSE Linux?
We have two tables of 5000 and 1000 records respectively but
LEFT JOIN takes over 10 minutes.
Can anyone give any guidance on this?
Thanks
Anthony Appleby
Indexes will solve it magically, post the query and table structures (if
not too big, you can also just post the revelant cols and indexes) and
maybe describe the select, and someone can advise you on indexes to
create, this join should be no problem.
Mike.
Anthony Appleby wrote:
Has anyone