如何统计嵌套数组中第三项为success的子数组数量并优化Apps Script性能？

Hey there! Your initial loop gets the job done, but when working with Google Apps Script—especially if you're dealing with larger datasets—we can optimize this to run faster while keeping the code clean. Let's break down the best approaches:

1. Use Array.reduce() (Recommended for Readability & Efficiency) #

The reduce() method is a native array function that's highly optimized in Apps Script's V8 engine. It lets you accumulate a count in a single pass without extra global variables:

const array = [['a','b','success'],['d','e','success'],['d','e','success']];
const successCount = array.reduce((total, row) => {
  // Add a safety check if some rows might not have a 3rd element
  return row.length >= 3 && row[2] === 'success' ? total + 1 : total;
}, 0);

This is concise, easy to read, and avoids manual loop index management. For most use cases, this will be just as fast (if not faster) than a manual for loop because of the engine-level optimizations.

2. Optimized Manual For Loop (For Extreme Large Datasets) #

If you're working with very large arrays (think tens of thousands of rows), a slightly tweaked for loop can squeeze out a tiny bit more performance by caching the array length and using block-scoped variables:

const array = [['a','b','success'],['d','e','success'],['d','e','success']];
let counter = 0;
const arrayLength = array.length; // Cache length to avoid repeated property lookups

for (let i = 0; i < arrayLength; i++) {
  const row = array[i];
  if (row.length >= 3 && row[2] === 'success') {
    counter++;
  }
}

By caching array.length, we avoid reading the array's length property on every iteration (a small but consistent saving). Using let/const instead of var also ensures proper block scoping, which helps the engine optimize execution.

Key Notes for Apps Script #

• If your array comes from a Google Sheets getValues() call, some rows might be shorter than 3 elements. Adding the row.length >= 3 check prevents runtime errors.
• Both methods are significantly better than using array.filter(row => row[2] === 'success').length—while filter is readable, it creates an entirely new array of matching rows, which wastes memory for large datasets.

内容的提问来源于stack exchange，提问作者eceo