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