I'm working on an app where the user can see the establishments closest to him.
In the bank I keep latitude and longitude, and in mobile I retrieve the user's position. I made a LIMIT in SQL to bring paged this data by ordering by the shortest distance. For this I made use of an algorithm to calculate these points.
But the customer informed me that the distance entered in the app and the distance in google maps are not accurate. Looking at it, I've verified that Google computes the route-based calculation.
How could I cross-reference this data using some google api by keeping my sort order in SQL?
I've already thought about putting a column in the database and going updating, but it's a lot of data for me to keep calling a webservice. Someone knows some solution to solve this "problem".