On Wed, Nov 23, 2011 at 6:13 PM, Platonides platonides@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