Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Selecting the top 10 results by count in MySQL


matrix_jan - 2:03 am on May 16, 2012 (gmt 0)


Not a problem,

Ok so you don't have an index on my_item. In order to shorten the query time index columns used in WHERE and ORDER BY. If you are using phpMyAdmin, it's very easy to add an index, just few clicks...

It would be great if you created a backup of the table before making any changes, in case if something goes left.

Good luck


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4453883.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com