scribu
Support for re-using term meta table
How would you feel about supporting use of the term meta table for relationships, instead of creating extra tables?
Some background: https://github.com/scribu/wp-posts-to-posts/wiki/Data-organization
In iteration 2, it did use the terms table to make connections, but the queries were pretty gnarly.
In this scenario, term meta would be used for storing per-connection data, not the connections themselves, because that would be too slow.
Even with the current custom tables, which have indexes in all the right places, queries are still slow sometimes (#219).
So, I don't have anything against it in principle, as long as it can be made performant (and as long as I don't have to debug the queries :P).
Also note that there's already a very similar plugin in spirit, which doesn't use any extra tables: https://github.com/voceconnect/objects-to-objects