From: Hank
Date: December 21 2005 6:33pm
Subject: Re: Do I need to tweak my server variables for this SELECT statement?
List-Archive: http://lists.mysql.com/mysql/193127
Message-Id: <1990a96b0512211033r370ed56eqd28a2781bc505fb1@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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