I am building a web app and part of this app will be information of other locations of the same type as the one the user is looking at. Such like "You are looking at a piece of data of a certain type... here are other locations of this type near to this one.."...
I have written php to go through all of the address and query for lat/lng.. and have written php to find the distances from one place to the other and am considering to store in a table
place1ID | place2ID | miles
( Where place IDs are INT(10) and miles is a 4,6 decimal )
but only where the distance from one to another is less than 2 miles... and only unique distances.. and not a distance from a place to itself..
My concern is the table of locations right now is about 15 thousand rows and so the resulting table for unique distances may be very large.. so I am concerned about size of resulting table as well as query time of that table to show the nearby location data..
Anybody have any input as to a better way to handle this?