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

[Stefan Baebler]

Instead of indexing by precise coordinates you could index by virtual
tiles as it is done in OSM's main DB since a year ago with nice
performance boost:

http://wiki.openstreetmap.org/index.php/QuadTiles

good luck,
Stefan


On Thu, Sep 11, 2008 at 1:49 PM, Andreas Kalsch <andreaskalsch at gmx.de> wrote:
> 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
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>