News for hackers. Stuff that matters.
Re:Calculate Latitude/Longitude Distances in MySQL with the ... by bad_user on Thursday October 28, 2010 @02:08AM (#1841948)
I'm not sure what the author is doing, but take a look at this presentation: http://www.scribd.com/doc/2569355/Geo-Distance-Search-with-M...

You can basically reduce the filtering done to something like: WHERE lat BETWEEN val1 AND val2 AND lon BETWEEN val3 AND val4.

So indexing will work.

There are no comments on this comment yet.