Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Calculate Latitude/Longitude Distances in MySQL with the Haversine Function. Parent comment
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.
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.