[OSM-talk] Announcing name searches for OSM
Hakan Tandogan
hakan at gurkensalat.com
Tue May 8 11:40:39 BST 2007
>> 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...
More information about the talk
mailing list