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

[Mikel Maron]

> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20080911/54bf065d/attachment.html>