| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Hank | Date: | December 23 2005 12:08am |
| Subject: | Re: Do I need to tweak my server variables for this SELECT statement? | ||
| View as plain text | |||
> Now that I know what's causing the slow queries, what can I do to fix it?
The only thing I can suggest is breaking up the query into two parts -
the first part to retrieve just the product codes and salesrank, and
sort and limit that.. save in a temp table or use application code to
retrieve and print the rest of the product info. Sorting 300,000+
records in that huge result set is going to take some time (although
it shouldn't take 10 minutes).
-Hank