[eluser]ozy123[/eluser]
This has probably been asked before but for some reason I can't figure out the best way to do this.
I'm trying to build a search function where a user can enter an address/postcode and search for any 'stores' that are x miles from the postcode.
The stores addresses have already been geocoded and stored in the datbase. However the postcode the user enters is unknown - do I geocode by making a http request to google api each time? I am going to have 5000+ users and they will carry out anywhere between 5 - 100 searches a day.
The site is UK based initially but eventually opening up to the US. Should I try and get a database of all postcodes/addresses along with coords in the UK and simply do a sql lookup?