I have a table of products with ~5000 records. I’d like to grab a subset of these records (about 1000 of them) using the API, and I already have the list of Record IDs that I want.
I’ve figured out two ways to get this data using
filterByFormula, but both methods take a long time to fetch 1000 records.
First method: takes about 20 seconds
OR( RECORD_ID = "a1b2c3", RECORD_ID = "a1b2c4", RECORD_ID = "a1b2c5", RECORD_ID = "a1b2c6" )
Second method: takes about 10 seconds
SEARCH(RECORD_ID(), "a1b2c3,a1b2c4,a1b2c5,a1b2c6") != ""
Are there any more efficient formulas I could be using here?