[Routing] "Connected Nodes"

[Sven Anders]

Am Dienstag, 9. Oktober 2007 13:13 schrieb 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
 
Great! Thank you.

     Sven