Re: CPU usage, need some help.
Yep, that's easy, do the following and your life will be much much better:
CREATE INDEX f1_id_index ON fb_qms_amis (f1_id);
CREATE INDEX f2_id_index ON fb_qms_amis (f2_id);
Also, depending on what version of MySQL you're using you may need to rewrite that query to use a UNION instead of OR. I'm certain version 5+ are fine, but I don't know when it was added to 4.
Subject
Written By
Posted
Re: CPU usage, need some help.
May 02, 2009 09:26PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.