In the last episode (Sep 26), David Griffiths said:
> ----- Original Message -----
> From: "Mike R. Duncan" <[EMAIL PROTECTED]>
> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, September 25, 2003 2:55 PM
> Subject: RE: Ideas on creating connections
Please don't hijack threads.
[ snip 2 queries ]
>
> The first one takes 1.73 seconds, the other takes 0.34 seconds.
>
> The only difference is the order of the tables (address_list comes
> last in the FROM clause in the first example, and is in the middle of
> the FROM clause in the second example)...
What does an EXPLAIN SELECT .. on both queries print? LEFT JOINs
definitely impose a table order, and it's possible MySQL is incorrectly
ordering other joins on those tables. You didn't mention what version
of MySQL you are using, btw.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
