u/PhillipLongman

I’m working on a complex spreadsheet with onEdit automations that range from slow to very slow.

I suspect half the problem is repeated fetching from the sheet. Since this data changes very little, I want to use an onOpen function to pre-fetch it and then hold onto it in some kind of data store.

• Long term, the data lives on the spreadsheet.
• It’s both structured and unstructured. There isn’t a ton of it. 
• The sheet only ever has one user at a time.
• During a typical session of usage, the computer will be put to sleep and woken up repeatedly.

I know frontend frameworks deal with this is a paradigm a lot, but I don’t have any experience with it. What’s the appropriate tool, here—Cache Service, Properties, localStorage, or something else?