[wp-hackers] Time for a wp_post_relationships table?
mikeschinkel at newclarity.net
Tue Aug 3 00:16:51 UTC 2010
Is it time to discuss a wp_post_relationships table? Michael Pretty made some rather insightful remarks on the topic last week and I've been bumping into the same:
On Jul 26, 2010, at 10:30 PM, Michael Pretty wrote:
> We have a couple more projects lined up where we need a many to many relationship between objects and have decided that for us the best option is to bite the bullet and create a new table. Its something we usually leave as a last resort, but at this point, that seems like the best option because of the issues you mentioned. I haven't yet worked out all the details of how it is going to work other than a table that stores parent_id, child_id and relationship_type, with lots of caching. At this point it just seems like it is going to be the only way to provide the many to many relationship that is both stable and provides decent performance.
So I submitted a "straw-man proposal" as a ticket on trac.
If you are interested in discussing it, PLEASE let's do it on the trac ticket.
More information about the wp-hackers