This is NOT an RTFM reply.
Hve you read
http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#L
EFT_JOIN_optimization
?
Cal
http://www.calevans.com
-----Original Message-----
From: Jordan Russell [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 2:05 PM
To: Gerald L. Clark
Cc: [EMAIL PROTECTED]
Subject: Re: Need help optimizing this (simple) query
> A .03 sec left join PREVENTS you from using MySQL.
>
> This must be a troll.
Sigh...
I guess I failed to mention this was a deliberately simplified example in
order to pose my question in a easy-to-understand manner. In reality, there
are much more records, and a more complex query, where the time does add
up...
My real question is, why does MySQL not use any index to sort when LEFT JOIN
is used. (Refer to the EXPLAIN SELECT output at the end of my message.)
Jordan Russell
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
