Optimizing Performance in Google Sheets and Beyond

10min Snip

00:00

Play full episode

Summary

Transcript

Episode notes

This chapter explores the performance optimization techniques in Google Sheets' calculation engine, particularly through string handling and data structures. It also discusses the evolution and expanding applications of WebAssembly, highlighting its potential to enhance code execution efficiency in web applications and beyond.

The Google Sheets calculation engine was originally written in Java and launched in 2006. In the early days of the product, all calculation happened on the server. However, starting in 2013 the engine has run in the browser using JavaScript.

Google Sheets is now one of the first products at Google to use WebAssembly Garbage Collection, or WasmGC, on Chrome.

Michael Thomas is the Multiplatform Lead for Google Workspace and Thomas Steiner is a Developer Relations Engineer at Google. They join the podcast to tell the story of why and how Google Sheets ported its calculation worker from JavaScript to WasmGC.

Sean’s been an academic, startup founder, and Googler. He has published works covering a wide range of topics from information visualization to quantum computing. Currently, Sean is Head of Marketing and Developer Relations at Skyflow and host of the podcast Partially Redacted, a podcast about privacy and security engineering. You can connect with Sean on Twitter @seanfalconer.