[wp-hackers] Taxonomy Schema Proposal
mark.wordpress at txfx.net
Wed Apr 18 23:22:44 GMT 2007
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.
Covered Web Services
More information about the wp-hackers