[wp-trac] [WordPress Trac] #14513: Time for a wp_post_relationships table?

[WordPress Trac]

#14513: Time for a wp_post_relationships table?
-----------------------------+----------------------------------------------
 Reporter:  mikeschinkel     |        Owner:                
     Type:  feature request  |       Status:  closed        
 Priority:  normal           |    Milestone:  Future Release
Component:  Post Types       |      Version:  3.0.1         
 Severity:  normal           |   Resolution:  wontfix       
 Keywords:                   |  
-----------------------------+----------------------------------------------

Comment(by scribu):

 > The above code is not so bad if there are <1000 or even <2500 records in
 wp_terms but if we have 10,000 records (movies) with 10 relationships a
 piece (actors) this absolutely does not scale.

 How is the number of relationships relevant? They are stored in the
 wp_term_relationships table.

 Please run through the actual queries that happen when using my API before
 saying "this absolutely does not scale".

 > your code current does not recognize the reciprocal relationship when
 one is encoded so a user would have to do both tasks: 1.) Add Actors to a
 Movie and 2.) Add Movies to an Actor which is crazy.

 Yes it does:

 {{{get_connected($id, 'from');}}}

 {{{get_connected($id, 'to');}}}

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