mercredi 23 septembre 2015

What is best - Fetch Information from MYSQL or store in SQLITE - Android

I am planning to implement a shopping APP in android.

I have some doubts in design:

  1. Products information is stored in MYSQL server, what is best way to display product information to user. I have 2 options in mind:
    1. Let the Information be there in MYSQL server itself, and when user ask for information, fetch it with web service and display to him. (In this way lot of network calls will be there from user's point of view. also the speed will be low to present the products due to network call)
    2. Fetch all the information in one go (when user installing the application) and store in SQlite Database in user's own mobile. (Memory consumption but speed will be high)

For updating the information in second case i have to sync with MYSQL and SQLITE whenever information is updated in MYSQL server.

What will be good option in this case.

If any other approach is better that is also welcomed.

Aucun commentaire:

Enregistrer un commentaire