[OSM-talk] Announcing name searches for OSM

[David Earl]

> Great ;-) I already sent you a short list of turkish characters off-list.

Yes, got them. They won't take effect until the next planet is reloaded.

> By the way, are the details of your setup (importing process, database
> layout) publicly available?

I've put an outline of the process on the wiki page. I will add more to it
today.

> Yesterday, I whipped up a perl script that
> should populate my own OSM-like database with multiple insert / update
> scripts, and it takes ages to process even a smallish area...

Indeed. Mine is in PHP and runs for about 10 hours to create the index. Much
of the time is spent doing queries to follow the ids from way to segement
and segement to node for all the data - actually running through the XML
isn't that slow in PHP. Once done I can discard the node and segment tables
I create to establish the linkage between things to just be left with the
index - the whole name/place index is less than 30Mb at the moment and
compresses into a 7Mb zip file.

David