[OSM-dev] Spatial vs. multi-column indexes for points
mikel_maron at yahoo.com
Thu Sep 11 20:11:45 BST 2008
> 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...
More information about the dev