I was under the impression that things end up in a tmp table if the query requires
sorting which is when you have either ORDER BY or GROUP BY or DISTINCT
Is that true of false?
regards,
thalis
On Tue, 24 Apr 2001, Seung-woo Nam wrote:
> 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
>
>
---------------------------------------------------------------------
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
