[wp-trac] Re: [WordPress Trac] #7650: Multiple post authors

[WordPress Trac]

#7650: Multiple post authors
----------------------+-----------------------------------------------------
  Reporter:  radzio   |        Type:  enhancement
    Status:  closed   |    Priority:  normal     
 Milestone:           |   Component:  Users      
   Version:  2.7      |    Severity:  normal     
Resolution:  wontfix  |    Keywords:             
----------------------+-----------------------------------------------------

Comment(by Denis-de-Bernardy):

 well, picture an NDB cluster for a sec (as I have), with a user trying to
 grab posts with authors A or B and tag C and D and category E or F.

 you've posts join user2post join users join term_relationships join
 term_relationships join term_relationships with or clauses. your cluster
 is dead... :-)

 (the taxonomy schema is dead wrong from the onset, in that the terms table
 should be merged into the term_taxonomy table, and the term_taxonomy field
 should ideally be an enum for optimization purposes, but that would be for
 a separate, faraway ticket.)

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