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