Re:Calculate Latitude/Longitude Distances in MySQL with the ...
by bravo_sierra on Thursday October 28, 2010 @02:08AM
(#1841950)
The edge cases happen all the time.
Using a B-Tree on a Geohash (like MongoDB does) is a bit more efficient that just indexing min/max values, but not by much. MySQL, PostgreSQL and even SQLite have R-Tree indices that perform 10x better.
Using a B-Tree on a Geohash (like MongoDB does) is a bit more efficient that just indexing min/max values, but not by much. MySQL, PostgreSQL and even SQLite have R-Tree indices that perform 10x better.