Improve long mysql query
- by John Adawan
I have a php mysql query like this
$query = "SELECT * FROM articles FORCE INDEX (articleindex) WHERE category='$thiscat' and did>'$thisdid' and mid!='$thismid' and status='1' and group='$thisgroup' and pid>'$thispid' LIMIT 10";
As optimization, I've indexed all the parameters in articleindex and I use force index to force mysql to use the…