| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Hank | Date: | December 23 2005 11:04pm |
| Subject: | Re: Do I need to tweak my server variables for this SELECT statement? | ||
| View as plain text | |||
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
