Google Apps脚本替代ScriptProperties [英] Google Apps Script alternative to ScriptProperties

问题描述

有人可以建议一个替代ScriptProperties作为存储和检索短期（文本）数据的方法。

我有一个内置于GAS的长期应用程序。因为它启动了一些'线程'，我存储了一些关于每个线程的信息，最终确定了所有线程何时完成，以及何时应用程序可以释放各种'锁'。

我使用ScriptProperties来存储这些信息。它过去完美地工作，但在过去6个月左右一直困扰着麻烦。问题主要是：
1.随着越来越多的脚本属性收集数据（应用程序清理脚本属性数据不可能），应用程序加载时间大幅增加
2.并发访问时（现在）ScriptProperties不可靠
3.无法快速读取或写入ScriptProperties

有人建议使用ScriptDb。任何人都可以确认这个（或任何其他）可行的解决方案吗？

非常感谢

解决方案

你可以看看CacheService吗？我用了很多成功。

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

解决方案

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

这篇关于Google Apps脚本替代ScriptProperties的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！