In the last episode (Jun 16), Jeremy Zawodny said:
> Err, I forgot to mention that there's a "Using filesort" in the
> output as well. That makes me believe it wants to write to disk (even
> if there may be sufficient RAM).
I'm not sure "Using filesort" actually means it is going to create a
file. The code seems to print "filesort" whenever an ORDER BY is
requested (sql_select.cc:536). Even the manual simply says "extra
pass". Maybe it required a file-based table in an earlier version, but
not anymore?
--
Dan Nelson
[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
