Utility of wordpress can be achieved by moving away from designations such as tag, category, post and page.
Every thing can be an "object" which in effect can serve the purpose of a category or tag or post.
# by mean of using the wp_posts table for everything, but with the addition of two columns. one for the object's parents, and one for it's children.
# this would effectively remove wp_terms and wp_term_taxonomy from the picture, instead directly using parent / child columns.
An object could be the category of another post, and could itself have several categories.
The key is being able to express various attributes of these objects:
url path: for each object, you may choose weather or not to show the hierarchy, and if so, which parent category of the object to use when displaying the path. or show the post date instead.
It can be controlled via a check box and the edit button can be modified to update the guid.
# path currently generated and placed in the guid field when "edit" is pressed
use guid to draw content,: no need to poll mysql half a dozen times
# this would solve the problem where wordpress must dip the database many times to determine what page it needs with the url presented.
content: All objects would have a post_content field. with any object, you may call "the_content" or "the_excerpt"
One unified table to handle everything, could be able to solve a few issues in current content extraction which might be producing necessary overhead. Even if not, the proposed functional changes would transform wordpress into the ultimate CMS
pulling content using the guid should reduce the number of database calls dramatically, instead of the current method which might do 8-12 to find out what page it is on
in the database, you can see that a page and post use the very same table, only separated by there designation. likewise tags and categories are the same. If the distinctions are essentially philosophical why not just open it all up for flexibility sake
Great job making wordpress by the way, its the best