[wp-hackers] Taxonomy Schema Proposal

[Mark Jaquith]

On Apr 18, 2007, at 5:04 PM, Matt Mullenweg wrote:

> Ultimately speed is going to be a big factor in any implementation,  
> I hope that the 3 additional tables and related queries don't hit  
> us too hard on the performance side.

If the API for updating/adding/removing tags and post categories is  
solid (i.e. we won't expect people to have a reason to circumvent  
it), we can cache cats/tags in postmeta whenever they are updated.   
That would actually REMOVE a query from the existing system (as  
postmeta is already queried).  The system could be fail-safe, so that  
if there is no appropriate _wp_categories postmeta entry, it can do  
the big JOIN'd query (and at that moment, populate the postmeta  
cache).  That doesn't help us for Tag/Category views (which posts  
have X taxonomy?), but it helps us when querying tags/categories for  
a given set of posts.

I'd assume that would be faster than doing a three-way JOIN'd  
query... it certainly sped UTW up.

--
Mark Jaquith
http://markjaquith.com/

Covered Web Services
http://coveredwebservices.com/