I'm experiencing high server load due to mysql.
I have lots of these queries:
SELECT * FROM tablea WHERE field1='XXX' AND field2='YYY' ORDER by timeset DESC LIMIT 1;
I'm retrieving around another 5 fields as a result.
Should i create a multi column index on tablea setting all 3 fields?
how can that be???
you're already retrieving all possible columns via your use of the dreaded, evil "select star"
Quiet right! So i need to list all the fields after the select. When you say it depends....?
quiet riot!!! one of da best metal bands evar!!
yup, it depends on which queries you want to run