3 ms·
But, why re-downloading every hour? Does merely having the spreadsheet passively open in a browser trigger that, or was some other process re-loading the sprea
by gojomo 15y ago
But, why re-downloading every hour?
Does merely having the spreadsheet passively open in a browser trigger that, or was some other process re-loading the spreadsheet every hour? (If the former, I wouldn't be as forgiving of Google. I understand the desire not to cache possibly-private data, but proper URL design and conditional GETs should be able to prevent the entire download on an automatic hourly schedule. And even if the latter – the author had chosen to reload the spreadsheet each hour – I'd want Google's design to allow browser-side caching to work for such embedded and/or generated images.)
- ardillamorris 15y agoThere must me something else to it because if the spreadsheet is sitting passively open there would be no need for Google to go an pre-fetch again.
- deleted 15y ago[deleted]
- jonknee 15y agoAbout an hour is the standard time for external data in Google Spreadsheet to be refreshed. I've come across this with JSON data.
- gojomo 15y agoEven if noone has it open in a browser? Or they do have it open, but haven't interacted with it? In either case, this seems odd, unless the URL is especially noted as 'volatile', and/or there are other parts of the spreadsheet that might trigger conditional calculations/notifications based on that URL's contents. (And don't S3 resources have last-modified-dates or etags for conditional GETs?)
- jonknee 15y agoI don't remember, but it wouldn't surprise me, that way it updates correctly for offline mode and if you have conditional logic it can work on changed data. It also improves page load time, which is very important for Google in general but doubly so for an online office suite (Excel opens quickly, so should a Google spreadsheet).
- spullara 15y agoI've seen this behavior with google gadgets as well, even with no user interaction or even having the page open.