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 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
>
> --------------------------------------------
> Web Site Strategy and Promotion
> ATL Strategic Communications Limited
> Welsbach House,
> Broomhill Road,
> London
> SW18 4JQ
>
> Tel: 020 8871 5119
> Mob: 0771 806 7044
> Fax: 020 8874 0084
> --------------------------------------------
> The information contained in this message is legally privileged and confidential
>information intended only for the use of the i
> ndividual or entity named above. If the reader of this message is not the intended
>recipient, you are hereby notified that any
> use, dissemination, distribution or copying of this message is strictly prohibited.
>If you have received this message in error,
> please notify us immediately on 0771 806 7044 and return the original message to us
>by email to [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
*********************************
Mike W. Baranski
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Web : http://www.secmgmt.com
Phone: 919-788-9200
Fax : 919-510-0037
P.O. box 30099
Raleigh, N.C. USA 27622
*********************************
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
