I have more than 420,000 rows articles in my table. I just want to query a data which is has only one row, but it takes too long.. any suggestion?
database : mysql, Storage engine : MyISAM
mysql_query("SELECT id, title, ... ,postdate FROM table_name WHERE id = 1
the result only one row.. but it take too long to open the page that query on more than 420,000 rows table