Based on the size (and # of colums) of your result set, I'm not sure any amount of RAM would allow 360,000 records to be stored and sorted entirely in memory. After some point, mysql just decideds to use a temp table.
That's the limit of my tweaking skills, so someone else is going to have to help out here on the way to maximize the memory or minimize the time for the internal sorting of the result set, if it's possible. -Hank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
