Currently the caching in Streamlit works only when one is switching between tabs within the dashboard. It would be great if the cached results were used more often for example: if one refreshes the page, or opens the dashboard in a new browser tab, or multiple users access the dashboard.
The easiest might be to check if there have been new updates in the db or if the latest timestamp is still the latest timestamp and if so, do not query the db again and use the cached results instead.
Currently the caching in Streamlit works only when one is switching between tabs within the dashboard. It would be great if the cached results were used more often for example: if one refreshes the page, or opens the dashboard in a new browser tab, or multiple users access the dashboard. The easiest might be to check if there have been new updates in the db or if the latest timestamp is still the latest timestamp and if so, do not query the db again and use the cached results instead.