[wp-trac] Re: [WordPress Trac] #5270: Private posts and tagging

[WordPress Trac]

#5270: Private posts and tagging
-----------------------------------+----------------------------------------
 Reporter:  McShelby               |        Owner:  pishmishy
     Type:  defect                 |       Status:  assigned 
 Priority:  normal                 |    Milestone:  2.6      
Component:  Security               |      Version:           
 Severity:  normal                 |   Resolution:           
 Keywords:  taxonomy tags privacy  |  
-----------------------------------+----------------------------------------
Comment (by McShelby):

 Another idea is, to move the 'term_taxonomy.count' field into another
 table and keep it per user. So the new term_taxonomy table would look like

 term_taxonomy_id
 term_id
 taxonomy
 description
 parent

 while the new table taxonomy_users looks like

 term_taxonomy_id
 user_id
 count

 If u is the amount of registered users in your blog and t is the amount of
 taxonomies, it would mean that the table taxonomy_users contains u*t
 amount of records. Depending on the size of the blog, the table may become
 quite big. This is nothing to worry to much, cause MySql can work with
 that pretty well - if the necessary keys and indexes are provided.

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