[wp-trac] Re: [WordPress Trac] #3723: Tagging

[WordPress Trac]

#3723: Tagging
-------------------------+--------------------------------------------------
 Reporter:  ryan         |        Owner:  ryan
     Type:  enhancement  |       Status:  new 
 Priority:  normal       |    Milestone:  2.2 
Component:  General      |      Version:  2.1 
 Severity:  normal       |   Resolution:      
 Keywords:  tags         |  
-------------------------+--------------------------------------------------
Comment (by ryan):

 COUNT() can be crazy expensive for some engines.  MySQL engineers
 suggested we just store the counts, and so we do for comments per post,
 posts per category, links per category, and so on.  We have API for
 eveything, so keeping counts in sync isn't too difficult.

 raw_tag is the tag name as given by the user.  tag is the sanitized
 version.

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