I’m working on an android app which pulls a long list of recipes names into a list view, which the user can filter through and then click on to get more details. The initial recipe list is going to have about 1000 entries and will be stored in an ever changing remote mySQL database. Upon clicking on a single recipe from the list view, the full recipe will be shown.
My question is as follows. Is it better for me to have a background service that pulls the entire list of recipes into a local SQLite database or should I just query the mySQL database every time the list view is pulled up? I’m not too worried about offline use, just optimizing my data structure to allow for a large user base.