Android app + MySQL database structure and design
===

Introduction: Let me first introduce you to my android app.
Its a food-review app which let user to give his/her review of a particular food of a restaurant.

Flow of the app :
1. User launches the app.
2. A list of nearby restaurants pops-up.
3. User selects a restaurant.
4. A list of menu of the selected restaurant is displayed.
5. User selects the food of which he/she wishes to give review/view the rating.

Progress so far: I used Google Place API to get a list of nearby restaurants. But the API does not give a searchable list of foods (menus) of the restaurant.

Issue: The menus, along with the restaurant, are required to be stored in the database along with the reviews of the dishes. If I make one table for restaurants and other table for menus of the restaurant then searching and retrieval time will become very huge.

Need: Can you please tell me how should I design my database so that the retrieval time is as less as micro seconds. Do I need to use some third party app for retrieving records in minimum time possible.

Please reply asap.
