Re: Do I need to tweak my server variables for this SELECT statement?

[Hank]

Ok, so the next step would be to try the original query with just the
LIMIT clause, and then just the ORDER BY (but not both).

The results of "select count(*)" query would be helpful to know just
how many records mysql is trying to sort and limit.

And do you really need a separte index key on `salesrank` on the
product table?

-Hank