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