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 [email protected] http://lists.openstreetmap.org/listinfo/dev

