On Wed, Nov 23, 2011 at 6:13 PM, Platonides <platonides(a)gmail.com> wrote:
UPDATE
tmpcategories
SET c_category = 'A-Class_Water_supply_and_sanitation_articles',
c_ranking = '425', c_replacement = 'A-Class'
WHERE c_project = 'Water_supply_and_sanitation' and c_rating= 'A-Class'
and c_type = 'quality'
I guess you could make the query sorter by splitting it adding a LIMIT
clause, then rexecing while the affected rows = limit. (Assuming you
don't need the UPDATE to be atomic)
The WHERE clause completely specifies a primary key, so at most one
row is affected. That's why it is surprising to me that it would take
very long.
- Carl