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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
