I have a cities table in MySQL with 3 rows in it.
row 1 'city'
row 2 'statename'
row 3 'stateabbreviation'
With 52,593 cities in the DB.
I would like to create an auto search form so that while typing a city in it will show possible results however, I am concerned about the speed of this and more importantly the proper approach.
I would really like to connect to an API that has all this info currently stored so that I can not only have the users find a city but it will find addresses as well. In addition, it will stay up to date.
As always, I appreciate the feedback and look forward to your suggestions.