News for hackers. Stuff that matters.

A comment on Calculate Latitude/Longitude Distances in MySQL with the Haversine Function. Parent comment

Re:Calculate Latitude/Longitude Distances in MySQL with the ... by bravo_sierra on Thursday October 28, 2010 @02:13AM (#1841959)
Using the Buffer function it does. Then MySQL will utilize the geometry index, rather than scanning the table. Not clear in the docs, but it's there.
[ Parent | on HN ]
Re:Calculate Latitude/Longitude Distances in MySQL with the ... by bad_user on Thursday October 28, 2010 @03:25AM (#1842076)
Do you have an example?
[ Parent | on HN ]
Re:Calculate Latitude/Longitude Distances in MySQL with the ... by thibaut_barrere on Thursday October 28, 2010 @04:35AM (#1842203)
I'm interested as well (really, as someone who uses sphinx for that currently).
[ Parent | on HN ]
Re:Calculate Latitude/Longitude Distances in MySQL with the ... by bad_user on Thursday October 28, 2010 @03:46PM (#1844589)
Hey, I'm also using Sphinx :)

Also, thing is filtering is not much of a problem as you can use the Haversine formula ... it gets to be a problem if you also want sorting from closest to furthest.

[ Parent | on HN ]