[OSM-talk] Announcing name searches for OSM

[Hakan Tandogan]

>> 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 segment

Did you create indices on your tables? Adding a simple "primary index" to
my tables (and using a transaction size of 1000 statements) sped up my
script from multiple hours to about 5 minutes...


Regards,
Hakan


-- 
The key to immortality is first living a life worth remembering...