| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Perrin Harkins | Date: | July 3 2007 2:58pm |
| Subject: | Re: peformance help: preventing 'using temporary; using filesort' | ||
| View as plain text | |||
On 6/29/07, Rich Brant <rbrant@stripped> wrote: > Hello all. I'm looking for help with the query below. Is there anyway > to prevent the temporary and filesort? The filesort is caused by either the ORDER BY or the GROUP BY. There are sections in the manual about how to get it to use indexes for these. That's the only way to prevent the filesort. - Perrin
| Thread | ||
|---|---|---|
| • peformance help: preventing 'using temporary; using filesort' | Rich Brant | 29 Jun |
| • Re: peformance help: preventing 'using temporary; using filesort' | Gerald L. Clark | 29 Jun |
| • Re: peformance help: preventing 'using temporary; using filesort' | Perrin Harkins | 3 Jul |
| • Re: peformance help: preventing 'using temporary; using filesort' | Sebastian Mendel | 3 Jul |