I have a question about loading pins from a Mysql database.
Let's say I have a database that stores several latitudes and longitudes and needs to load some pins from them via the GMaps API.
However, this gave me a question: My intention is to upload a map based on the user's location and load the appropriate pins, if they correspond to that location. However, in order to do this, would it be necessary to traverse the entire database to each user's movement? If I have a large number of lat / long would this not affect performance? Can you suggest a better way to do it?