Google Sheet and Airtable queries seem slow on first query

[steve_synopsis]

Hi,

I have a datasource (56 rows, 4 columns) both in Google Sheets and Airtable and am running a simple query. I enter an SKU and the code loops through the data until the entered SKU matches the SKU in the row. At that point I break out of the loop and display the data.

What I have found is that if I search for the last SKU in row 56, the search takes about 22 seconds, but a subsequent search to row 55 in the same app session takes just over 1 second. I am assuming that this some sort of caching but how can I correct it so that the first run is quicker?

This happens in both Google Sheets and Airtable.

A link to a screen share is here

Thanks
Steve

[tatiang]

There’s a much easier way to do this.

The Find First Occurrence of block will return a 0 if the search term doesn’t exist and a number greater than 0 if it does. That number represents the row number where the term was found. You can use that block with the List of Values block to quickly determine if the value exists in a column in your data source.