How to handle the delay to get data into the newTableView ?

Solar2D Widgets
1

Hi All,

i have TableView that reads data from remote SQL database using json. When the app start the user has to click a button to view the new data…

I noticed a delay for fetching the data and sometimes it failed if the network is weak, So he gets the table empty. How to handle such delay ? 

should i use some sort of caching to show some data or what … as i see the app does not look good to show empty in place of the table before he clicks…

thanks

Abdul

2

It’s a good idea to cache the data for situations like Airplane mode or when there is no connectivity.

3

aha, do you mean to use local sql database ??

also what about the first time to load the data…

Thank

Abdul

4

That probably would work.

5

thanks Rob,  do you think the following steps are good…

  • install local db when the user install the app

  • the local db contains same structure as the remote db

  • the first time will load the data from remote db to local db…

  • each time the user clicks the button the tableview will read form local db

  • the app should check for new records and update then the local db…

regards

Abdul

6

That sounds reasonable.

7

thanks,

8

It’s a good idea to cache the data for situations like Airplane mode or when there is no connectivity.

9

aha, do you mean to use local sql database ??

also what about the first time to load the data…

Thank

Abdul

10

That probably would work.

11

thanks Rob,  do you think the following steps are good…

  • install local db when the user install the app

  • the local db contains same structure as the remote db

  • the first time will load the data from remote db to local db…

  • each time the user clicks the button the tableview will read form local db

  • the app should check for new records and update then the local db…

regards

Abdul

12

That sounds reasonable.

13

thanks,