Talk:Advanced relationships/Implementation

Link tables for nodes, ways, and segments

I don't like this idea all that much. A few thoughts why:

• Finding out whether an object is part of a relationship - which will be a very common operation as you need to prohibit deletion of such objects, and you also may need to return such objects together with their partners - requires searching SIX tables each time (e.g. you have a node, you need to search link_node_* and link_*_node). There must be other ways. I will sketch one on the page shortly.

• I think/hope that the abolution of segments will come before this; even if it doesn't, we must not make that more complicated by allowing segments to become partners in relationships

• Versioning needs to be taken care of

--Frederik Ramm 02:17, 15 June 2007 (BST)