I don't think you can avoid having those temporary tables in executing
any kind of SELECT queries since the retrieved information should be
stored somewhere (whether you have ORDER BY or not). I would suggest
that if you have a large database, you should considering putting the
temporary space on a separate hard drive.
Seung-woo Nam
Scott wrote:
>
> >That ORDER by a calculated_field DESC is killing you.
> >It needs to go to a temporary table for sorting.
>
> The problem, though, is that even if I leave the ORDER clause out, or
> ORDER BY any other field, the same thing happens. I initially thought
> the same thing, but it happens with or without the ORDER BY clause.
>
> Scott
>
<snip>
---------------------------------------------------------------------
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
