On 23 Apr 2004, at 9:48 pm, [EMAIL PROTECTED] wrote:
Relevant `explain` details: Full table scan: 22,371,273 rows, Using temporary; Using filesort
The filesort is a giveaway. Can you increase the sort buffer size so that the sort can happen in memory rather than having to use a file to sort?
Tim
-- Dr Tim Cutts Informatics Systems Group Wellcome Trust Sanger Institute Hinxton, Cambridge, CB10 1SA, UK
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]