Spreadsheet or script properties for simple index in Google apps script? -


i'm programming google apps script store tiddliwiki (tiddlywiki.com). receives files , store them within google drive. never overwrites file, creates new 1 on every upload. performance reasons want maintain index of latest version of each file , id. i'm using properties service achieve this. when file uploaded, store name:id. way retrieving file name not require search in full folder neither check latest version. i'm worried how many entries can store on script properties store. i'm thinking using spreadsheet save index, don't know difference in terms of performance compared properties service.

here question: can stick properties service achieve task or should switch google spreadsheets? performance worse? alternative index?

thanks in advance.

edit: since store few hundred of entries, using json file index. take time load text , parse it?

it depends on amount of files you're expecting. few thousand files, property service might , surely easier use spreadsheet, has tighter limitation of 500kb per store.

if think you'll have more files, it's best not index @ all, , fast google drive search retrieve latest file. search criteria can specific , fast (filter title or timestamp criteria). think it'll less trouble in script (than trying build/fit big index memory, etc).


Comments

Popular posts from this blog

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -