---
title: "Performance report for CacheService versus SpreadsheetApp for read/write in Google Apps Script"
author: "Martin Hawksey"
date: 2023-03-14T22:53:56+00:00
canonical_url: https://pulse.appsscript.info/p/2023/03/performance-report-for-cacheservice-versus-spreadsheetapp-for-read-write-in-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2023/03/performance-report-for-cacheservice-versus-spreadsheetapp-for-read-write-in-google-apps-script.md
categories:
  - "Advanced"
  - "Gotchas"
  - "Sheets"
tags:
  - "ilopezosaserrano"
  - "Medium"
featured_image: https://pulse.appsscript.info/files/2023/03/1_Gaxl8fDlIzeHYwMN6SMBxQ.png
description: "An interesting report from Ignacio Lopezosa Serrano on the relative performance of CacheService and SpreadsheetApp for reading/writing data with Google Apps Script. Some surprising results and something I think to be kept in mind is how these tests compare to 'real world' conditions. As also pointed out in the post there are some  service limitations of CacheService to keep in mind particularly around storage size limits.  "
---

# Performance report for CacheService versus SpreadsheetApp for read/write in Google Apps Script

![Performance report for CacheService versus SpreadsheetApp for read/write in Google Apps Script](https://pulse.appsscript.info/files/2023/03/1_Gaxl8fDlIzeHYwMN6SMBxQ.png)

> Image credit: Ignacio Lopezosa Serrano
> For read-heavy applications that don’t involve components external to Apps Script accessing the cache and don’t exceed the CacheService limits, use CacheService. For write-heavy applications or for when some external parts require access to the same cache, use Spreadsheet App.

An interesting report from Ignacio Lopezosa Serrano on the relative performance of CacheService and SpreadsheetApp for reading/writing data with Google Apps Script. Some surprising results and something I think to be kept in mind is how these tests compare to ‘real world’ conditions. As also pointed out in the post there are some  service limitations of CacheService to keep in mind particularly around storage size limits.

Source: *[The use of Caches in Google Apps Script*](https://medium.com/@ilopezosaserrano/the-use-of-caches-in-google-apps-script-715a4ea8a6a)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2023/03/performance-report-for-cacheservice-versus-spreadsheetapp-for-read-write-in-google-apps-script/](https://pulse.appsscript.info/p/2023/03/performance-report-for-cacheservice-versus-spreadsheetapp-for-read-write-in-google-apps-script/)*