http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html
" Do not use DELAYED with INSERT ... SELECT. " With respect to the table structure...can you explain how when you have to read every single row regardless how the structure (assuming you are going down the path of idexes) affects the query? Cliff Donny Simonton <[EMAIL PROTECTED]> writes: > Use insert delayed, and you will cut your time in half. At least with my > experience. But also how long does it actually take to run the query > itself. Giving a summary explain doesn't help much. You really need a > table structure that the select is using and a full explain. > > Donny > > > -----Original Message----- > > From: Tim Cutts [mailto:[EMAIL PROTECTED] > > Sent: Saturday, April 24, 2004 6:02 AM > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject: Re: SLOW 22million rows, 5 hour query? > > > > > > 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] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
