I am building an Android app with capacitor where I use a collection of about 200.000 geographical objects (about 2-4 Mb data in total). The objects originally are retrieved from a a server.
To get a fast load time for my app I see a number of scenarios for these data:
- Load all the data from the server at startup of the app
- Load only the data from the server that is required for the initial map shown in the app (typically 100 objects)
- Store the data locally on the mobile device as a json-file
- Store the data locally on the mobile device as an sql database (using the sqlite plugin)
I expect the complexity of the app will increase from 1->4. But what will it mean for the loading time?