[Routing] "Connected Nodes"

[Frederik Ramm]

Hi,

>> alter table way_nodes add key (node_id);
>
> As far as I can tell, this is unnecessary, since current_way_nodes
> already has this index.

> Longer-term, it also breaks because way_nodes
> will have historical stuff?

Yes of course. Doing it properly on the main DB would require using  
the current_way_nodes table instead of way_nodes. I was in the lucky  
situation to have a reasonably clean database so I could rund  
everything on the faster MyISAM tables rather than on  
current_way_nodes which is InnoDB. Anyone having just imported a  
planet file into a clean DB will be in the same situation.

Bye
Frederik

-- 
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00.09' E008°23.33'