> My current optimization includes: > > - using mediumint for lat/lon - enough for ~2 meters resolution > - using a bounding box first for point+radius calculation and then selecting > the circle with a Pythagoras approximation, which is exact enough > > For the first, I want to use MySQL. > > If you are interested in some benchmark data, I can post ...
As an aside, there is currently a lack of good benchmarks on the different optimizations & hacks for spatial querying, in different circumstances, so anything contributing towards guidelines for developers would be most helpful
_______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev