News for hackers. Stuff that matters.
Re:Calculate Latitude/Longitude Distances in MySQL with the ... by bravo_sierra on Thursday October 28, 2010 @02:02AM (#1841935)
For what? How?
Re:Calculate Latitude/Longitude Distances in MySQL with the ... by joshu on Friday October 29, 2010 @01:37AM (#1846291)
Hash the points into large tiles. Only calculate the nearby tiles, then find the items that are in the list of tiles (which is faster, due to being indexed.) Then use Haversine or whatever to filter.