<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt">> My current optimization includes:<br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">> <br>> - using mediumint for lat/lon - enough for ~2 meters resolution<br>> - using a bounding box first for point+radius calculation and then selecting the circle with a Pythagoras approximation, which is exact enough<br>> <br>> For the first, I want to use MySQL.<br>> <br>> If you are interested in some benchmark data, I can post ...<br><br>As an aside, there is currently a lack of good benchmarks on the different optimizations & hacks for spatial querying, in different circumstances,<br>so anything contributing towards guidelines for developers would be most
helpful<br></div></div></div></body></html>