Re: update query optimization
Posted by:
Rick James
Date: April 03, 2009 06:43PM
Do you have an index on audience_member_reg_id?
Or an index that _starts_ with audience_member_reg_id?
And is audience_member_reg_id an INT (or similar type, not CHAR)?
The EXPLAIN wasn't useful because it discovered that the desired audience_member_reg_id was not to be found. Try it with a value that does exist.
Or are you saying that the 20sec updates happen when the audience_member_reg_id is missing?
MyISAM or InnoDB (I suspect InnoDB).
4.0? 4.1? 5.0? 5.1? (I suspect older version.)
Subject
Views
Written By
Posted
4180
April 02, 2009 02:17AM
Re: update query optimization
2437
April 03, 2009 06:43PM
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.