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

[WordPress Trac]

#4365: Deleting a category scales poorly
--------------------------+-------------------------------------------------
 Reporter:  markjaquith   |       Owner:             
     Type:  defect (bug)  |      Status:  assigned   
 Priority:  normal        |   Milestone:  2.9        
Component:  Performance   |     Version:             
 Severity:  normal        |    Keywords:  needs-patch
--------------------------+-------------------------------------------------

Comment(by hakre):

 Was able to test now. Did not take minutes over here but some time. The
 impact is further lighter if you delete by ajax request which is now the
 default if javascript is enabled.

 Bulk deletion does take it's time anyway.

 wp_delete_category($cat_ID)
 wp_delete_term($cat_ID, 'category', array('default' => $default))

 This is all because of the model. The last routine iterates over every
 object that is bound to a term instead of just removing the taxonomy link
 to the object.

 So this is documented so far with the according lines:
  * markjaquith  2007.10.13 05:51:11           prepare(), insert(),
 update() for wp-includes/ taxonomy.php, rss.php, registration.php
  * ryan  2007.06.19 02:33:44           Add some taxonomy validation.
 Rearrange funcs.
  * westi  2009.03.18 22:06:49          Allow wp_delete_term users to force
 all objects to have a new term applied.  Allow for category merging use-
 case. Fixes #9355.

 So this looks like this is by intention since #9355 and therefore I assume
 this wontfix.

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