How do you do your ETL in shiny?
I deployed an app in shinyapps.io and it takes a long while to load (~10 sec sec).
I think my etl is bad, and google results dont help either.
The app GETs data from KoBoToolbox's API every time I start the app, I shaved a few sec by caching the data but its not good when user wants to get the latest data with a refresh button (which calls the api, and reloads the plots).
I stopped working on it recently since working with the server file is tedious. Right now the app is split into 5 scripts, with bunch of etl functions saved in 2 of them, and I set aside calculated objects in one.
Is it possible to do away with the refresh button and make the shiny server run the GET requests every interval like how Google Scripts work?