Continuing the discussion from How fast is searching for a specific value in a field (column)?:
I did a test to check in practice how searching for a single value using Airtable API scales with the number of rows and it turns out that there’s no problem with that.
Here’s a table that I got that shows the number of rows in an Airabse table and how long it takes to find a given user ID string in seconds:
rows, time 1, 0.52 10, 0.39 100, 0.39 1000, 0.41 10000, 0.47 50000, 0.75