I've got a Shiny app that is simple, but renders interactive plots based on ~6GB worth of data. All data are currently deployed in memory with my app.R file in shinyapps.io, but the app loading time and app performance are horrendously slow.
I've looked into hosting the data in a MySQL database, using tips for faster data loading (like 'fread'), using performance boosting tricks (like bindCache), and consulting with experts to 'optimize' my the code (with trickys like decreasing redundant reactivity) - but it seems like the issue is proving quite tricky to resolve.
In general, is there a significant difference in Shiny app speed depending on where the app is hosted (my own server vs shinyapps.io vs rstudioconnect ?)
Will displaying my shinyapp on my website via an iframe (connected to the shinyapps.io url) have an effect on my apps loading speed?
Are there any examples I can see of fast-loading, responsive Shiny apps that are based on larger (>5GB?) of data?