Calculate Latitude/Longitude Distances in MySQL with the Haversine Function

Re:Calculate Latitude/Longitude Distances in MySQL with the ... by bravo_sierra on Thursday October 28, 2010 @02:01AM (#1841934)

Why in the world would you use this when MySQL has almost proper geospatial support? It's far more efficient and less incorrect.

I swear - next time I'm going to get a R-Tree novelty account.

[ Parent | on HN ]

Re:Calculate Latitude/Longitude Distances in MySQL with the ... by bad_user on Thursday October 28, 2010 @02:05AM (#1841946)

Because Mysql doesn't have support for distance searches.

[ Parent | on HN ]

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 ]

Re:Calculate Latitude/Longitude Distances in MySQL with the ... by codesink on Thursday October 28, 2010 @04:31AM (#1842197)

geospatial index do NOT work if you're using InnoDB; so you must choose between geospatial queries or transactions (that MyISAM don't support).

[ Parent | on HN ]