CODEWITHSUNDEEP
google-apps-script
user1507412
user1507412

Reputation: 39

Google Apps Script alternative to ScriptProperties

Can someone suggest an alternative to ScriptProperties as a means of storing and retrieving short-term (textual) data.

I have a long-standing application built in GAS. Because it kicks off a number of 'threads' I store some information about each thread, ultimately to determine when all the threads have finished and thus when the application can release various 'locks'.

I'm using ScriptProperties to store this information. It used to work perfectly but has been beset by troubles over the last 6 months or so. The problems are mainly: 1. Application load times increase massively as more and more data collects in script properties (it isnt possible to clean down scriptproperty data) 2. ScriptProperties are (now) unreliable under concurrent access 3. ScriptProperties can't be read or written to in rapid bursts

Someone has suggested using ScriptDb. Can anyone confirm this (or any other) viable solution?

Many thanks

Upvotes: 0

Views: 839

Answers (2)

Corey G
Corey G

Reputation: 7858

CacheService is only best-effort and is not intended for guaranteed storage (but it is fast!). If you need to be sure it will be there, use ScriptDb.

Upvotes: 0

Srik
Srik

Reputation: 7957

Can you have a look at CacheService ? I have used with lot of success.

Upvotes: 1

Related Questions