[wp-trac] Re: [WordPress Trac] #5183: General Meta-Data Table

[WordPress Trac]

#5183: General Meta-Data Table
-----------------------------------------+----------------------------------
 Reporter:  filosofo                     |        Owner:  anonymous     
     Type:  enhancement                  |       Status:  reopened      
 Priority:  normal                       |    Milestone:  Future Release
Component:  General                      |      Version:  2.9           
 Severity:  normal                       |   Resolution:                
 Keywords:  needs-patch meta-table meta  |  
-----------------------------------------+----------------------------------

Comment(by Denis-de-Bernardy):

 There are occasions where you some DB integrity is very desired. When
 dealing with accounting-related data, for instance: if you delete a user,
 you need to be sure that the query will fail if it's about to delete lines
 in your accounting.

 Don't get me wrong, I'm not saying we should have a posts, pages,
 post_revisions, etc. tables. Just like you I like the fact that we're able
 to store attachments and cats and dogs in there.

 When it comes to properly optimize the queries afterwards, joining posts
 with a table contains IDs from posts, comments, links and users won't fare
 as well as one on a table that contains IDs from a single one.

 Now, if we introduce some kind of node ID so as to ensure no two pieces of
 data in posts, comments, links and users share the same numeric ID, that's
 a different story. Generic meta and term2node tables then makes perfect
 sense. But that's a much more massive change.

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