tanaikech

Benchmark: Process Costs for Searching Values in Spreadsheet using Google Apps Script

Introduction

Here, I would like to report the process costs for searching values in Spreadsheet using Google Apps Script (GAS). When the values are searched in Google Spreadsheet, the following 3 patterns can be considered. Ref

1. Retrieve all values using getValues, and the values are searched from the retrieved array.
2. Use TextFinder.
3. Use Query language.