- - Code, Content, and Presentation
- -- Databases
- ---- Selecting the top 10 results by count in MySQL
matrix_jan - 10:00 pm on May 15, 2012 (gmt 0)
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.
Thread source: http://www.webmasterworld.com/databases_sql_mysql/4453883.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com