Hi, I'm trying to develop an app wherein I'll be storing customer details in a database (name, address, products offered etc..).
How does this make you feel?
Optional
Happy
Silly
Indifferent
Sad
Related Category
App Development x
Preview & Ask My Question
The idea being that I would invoke a google location look up on the device, identify where the user is located and display results of those 'customers' within 'X' radius of the device location. I envisage the customer database initially comprising of 100 or so customers, but could potentially increase to 500+. Given that how would you suggest I approach this?
Based upon what I have read thus far I believe I could either 1) retrieve all of the database records, store them locally on the handset and perform the calculations to determine whether they are within the defined radius or not, or 2) pass the handset location up to a server script and then query the database and return the results to the app that are within 'X' radius of their location.
Would you recommend either of the methods above over the other? (if so may I ask why? Or is there a better way to do it?
Many thanks in advance for your advice 
.
Best
John.