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,