[wp-trac] [WordPress Trac] #56598: Performance optimization in _update_post_term_count()

[WordPress Trac]

#56598: Performance optimization in _update_post_term_count()
-------------------------+--------------------------
 Reporter:  dimitrisv    |       Owner:  (none)
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  6.4
Component:  Taxonomy     |     Version:  6.0.2
 Severity:  critical     |  Resolution:
 Keywords:  needs-patch  |     Focuses:  performance
-------------------------+--------------------------

Comment (by peterwilsoncc):

 In #40351, a switch to partial term counts (using increment and decrement)
 was attempted but I ended up reverting my patch because it broke plugins
 using hooks to set additional terms.

 The performance of term counting IS very bad so there's a lot of room to
 improve the performance by avoiding the need for scanning multiple tables,
 etc.

 (Sorry for the double notification, premature send)

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/56598#comment:5>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform