title: Searching through a Range with TextFinder is slower than searching the entire Sheet
body: <p>I have a sheet with a lot of rows -- thousands. I want to search a specific column for text. I am using <code>Range.createTextFinder</code> but it times out. It even times out if the Sheet only has 4 rows of data.</p>
  
  <pre><code>// This is very slow
  var found = sheet.getRange("A:A").createTextFinder("dog").matchCase(false).findNext();
  </code></pre>
  
  <p>If I search the entire sheet it is pretty fast but I want to only check a specific column.</p>
  
  <pre><code>// This works faster but it searches the entire sheet
  var found = sheet.createTextFinder("dog").matchCase(false).findNext();
  </code></pre>
  
  <p>Is there a faster way to find the first row that has a string in a specific column?</p>
  
  <p><strong>Update</strong>: Here is the execution transcript:</p>
  
  <pre><code>[19-06-09 14:16:48:430 EDT] Starting execution
  [19-06-09 14:16:48:513 EDT] SpreadsheetApp.openById([redacted]) [0.071 seconds]
  [19-06-09 14:16:48:513 EDT] Spreadsheet.getSheetByName([Sheet2]) [0 seconds]
  [19-06-09 14:16:48:514 EDT] Sheet.createTextFinder([b]) [0 seconds]
  [19-06-09 14:16:48:514 EDT] TextFinder.matchCase([false]) [0 seconds]
  [19-06-09 14:16:48:595 EDT] TextFinder.findNext() [0.08 seconds]
  [19-06-09 14:16:48:596 EDT] Sheet.getRange([A:A]) [0 seconds]
  [19-06-09 14:16:48:596 EDT] Range.createTextFinder([b]) [0 seconds]
  [19-06-09 14:16:48:597 EDT] TextFinder.matchCase([false]) [0 seconds]
  [19-06-09 14:17:21:064 EDT] TextFinder.findNext() [32.467 seconds]
  [19-06-09 14:17:21:072 EDT] Execution failed: Service error: Spreadsheets (line 103, file "main") [32.626 seconds total runtime]
  </code></pre>