[OSM-dev] Spatial vs. multi-column indexes for points

[Andreas Kalsch]

Hey,

last week I made some experiments with huge datasets of lat/lon points. I use MySQL 5.0, which partially support GIS extensions, including R-trees. But it is still not able to make queries based on the GIS features, so I have to use the normal way - multi-column indexes on lat/lon columns. It works well but probably there is a way to make it even quicker ;)

Has anybody used GIS successfully in MySQL or PGSQL and can tell me how the performance compares between the two techniques?

Thanks,

Andi
-- 
Psssst! Schon das coole Video vom GMX MultiMessenger gesehen?
Der Eine für Alle: http://www.gmx.net/de/go/messenger03