On Wed, Nov 23, 2011 at 6:13 PM, Platonides <[email protected]> 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 _______________________________________________ Toolserver-l mailing list ([email protected]) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
