On Thu, Aug 21, 2003 at 05:59:54PM +0200, Mechain Marc wrote: > > What is the value of "sort_buffer_size", may be you could > increase the value for having faster ORDER BY (all in memory > intead of using temporary file on disk).
I had previously tried that--I sometimes have big GROUP BY queries as well--so the sort_buffer_size is now 8M; though I don't usually have many simultaneous users, I'm still nervous about making it much larger than that. Best, Jesse Sheidlower -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]