Morbus Iff wrote:
In working with taxonomy, I'm now leaning toward the following as a replacement for term_node (I'm using words here for readability, but assume all "id" columns are, in fact, numbers):
tid | uid | type | id ----------------------------- cat | morbus | image | 67 cat | moshe | node | 17 dog | killes | comment | 129 cool | dries | user | 1
Difficult to say without proper benchmarking. I'm sure some relations are better captured in separate tables, while for some relations it might be beneficial to use a single table. It all depends on how you want to use (query) the data, and how frequent. Personally, I'd start off with extending taxonomy for folksonomies and nothing more. -- Dries Buytaert :: http://www.buytaert.net/