search

bcgov / watershedBC

Summarize watershed attributes in BC
https://bcgov-env.shinyapps.io/watershedBC/
Apache License 2.0
6 stars 0 forks source link

Scaling to production #24

Closed bevingtona closed 8 months ago

bevingtona commented 8 months ago

Not currently built for production... Slows down with too many concurrent users.

Need to load test and benchmark performance.

https://github.com/hadley/mastering-shiny/blob/master/scaling-performance.Rmd

Then potentially move some computation to JavaScript and use shinyworkers to distribute computation...

bevingtona commented 8 months ago

in the meantime... could spin up different endpoints for different teams... even password protect a few for critical work. Seems it is a shinyapps.io scalling problem, not a database problem.

For example [url]/watershedBC_RESEARCH For example [url]/watershedBC_AUTHORIZATION For example [url]/watershedBC_DRINKING_WATER

bevingtona commented 8 months ago

swapped the DBI lib to pool, seems stable