Properties Service Taking FOREVER

[Jacob Edward]

The quota says you get 500kb... if you want to fill the whole properties store in one process with 50+ 9kb segments, it takes way too long... I thought it was suppose to be something like RAM, or is that just the CacheService?  Is there anything else?  Cache is suppose to only last for 20 minutes and is limited to 100kb per script... right?  Per script?

[Adam Morris]

There do seem to be a lot of questions about CacheService lately. Documentation says default is 10 minutes but max is 21600 (6 hours). 

————————————————————————————

Adam Morris | IT Systems & English Teacher | IGB International School
Jalan Sierramas Utama, Sierramas,
47000 Sungai Buloh, Selangor DE, Malaysia

t    +60 3 6145 4688
f    +60 3 6145 4600
w   www.igbis.edu.my
e    adam....@igbis.edu.my

————————————————————————————

On Tue, Apr 30, 2019 at 4:36 AM oughtimpliescan1 <oughtimp...@gmail.com> wrote:

The quota says you get 500kb... if you want to fill the whole properties store in one process with 50+ 9kb segments, it takes way too long... I thought it was suppose to be something like RAM, or is that just the CacheService?  Is there anything else?  Cache is suppose to only last for 20 minutes and is limited to 100kb per script... right?  Per script?

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-script-community.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/e8732e32-2b37-4fad-aa5a-a6d65f2959b0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jacob Edward]

It also says 100kb per key... does that mean I could just load terabytes into CacheService in 100kb chunks all within the same script?

[Adam Morris]

I don't know what the max storage is but the point of a cache is that if you pass it by attempting to store more values, then it'll flush to accommodate which will not be available on next call; you have to code to anticipate that.

At least, that is my own working understanding of how it works.

Your use case sounds like you might be interested in the library I wrote which makes all this a cinch.

https://github.com/classroomtechtools/modularLibraries.gs/tree/master/Stores/ObjectStore

————————————————————————————

Adam Morris | IT Systems & English Teacher | IGB International School
Jalan Sierramas Utama, Sierramas,
47000 Sungai Buloh, Selangor DE, Malaysia

t    +60 3 6145 4688
f    +60 3 6145 4600
w   www.igbis.edu.my
e    adam....@igbis.edu.my

————————————————————————————

On Tue, Apr 30, 2019 at 8:03 AM oughtimpliescan1 <oughtimp...@gmail.com> wrote:

It also says 100kb per key... does that mean I could just load terabytes into CacheService in 100kb chunks all within the same script?

--

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-script-community.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/416235f7-ee35-4697-9e22-58aa0a48501a%40googlegroups.com.