[Routing] data-structures used

[Stefan de Konink]

On Thu, 24 Jan 2008, Marcus Wolschon wrote:

> What is everyone using for on-disk
> and in-memory datastructures to store
> the map locally for routing and map-rendering?

Would this preferably not the same? So one is able to MMAP the file?

> I tried quite a number of ways including
> using the osmosis-schema on mysql and later
> hsqldb and currently a combination of a
> hsqldb indexing name->id and id->tilenr
> and one xml-file per tile seems to be the fastest
> I could find. (Surprising as it seems that
> this outperforms mysql with proper indice.)
>
> I did not test any of the geodata-extensions
> for mysql and postgreSQL because I cannot
> expect an end-user to install them properly
> on his/her laptop.

I'm experimenting with the Geom extentions to MonetDB, not stable and easy
to say somewhat broken, but the complete architecture should be
shrinkable.


Stefan