[wp-trac] Re: [WordPress Trac] #4365: Deleting a category scales poorly

[WordPress Trac]

#4365: Deleting a category scales poorly
--------------------------+-------------------------------------------------
 Reporter:  markjaquith   |        Owner:  ryan
     Type:  defect (bug)  |       Status:  new 
 Priority:  normal        |    Milestone:  2.9 
Component:  Taxonomy      |      Version:      
 Severity:  normal        |   Resolution:      
 Keywords:  needs-patch   |  
--------------------------+-------------------------------------------------
Comment (by Denis-de-Bernardy):

 wontfix imo. the slow area is this, from within a foreach loop:

 wp_set_object_terms($object, $terms, $taxonomy);

 the *proper* workaround would be to use an sql trigger, but that is not an
 option until mysql4.x is a thing of the past.

 the other potential workaround would be some kind of
 wp_refresh_object_terms($object_ids) function, which updates the post
 counts accordingly.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/4365#comment:3>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software