Page is a not externally linkable
- Code, Content, and Presentation
---- Selecting the top 10 results by count in MySQL
matrix_jan - 10:00 pm on May 15, 2012 (gmt 0)Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4453883.htm
What's the query time without LIMIT?
Count() is slowing the query time down when there is no index, do you have one on the table?
Also try explain + query to see what's going on.
Brought to you by WebmasterWorld: http://www.webmasterworld.com