Connection between streamlit and google sheets make the app considerably slow

Using Streamlit
1

I have a very simple web app in streamlit. It is connected with google sheets. But these two lines make my app very slow!

s=Spread(spreadsheetname,client=client)
sh=client.open(spreadsheetname)

In every interaction, the streamlit run the whole code again, that’s why these two lines create problems. How can I solve the issue?

2

Hi @Sinakian,

Thanks for posting!

You can use caching to avoid re-running time-consuming parts of your code.

Caroline :balloon:

3

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.