Apr 30, 2021 12:47 PM
Our company is deeply integrated with the Airtable API. In fact, we help other companies build on Airtable - so we monitor the Airtable API closely.
Up until a month ago, all our API requests to Airtable were GET
requests. With the launch of our proxy, we’re now servicing PATCH/POST/DELETE
requests as well.
With these new requests, we began to notice some unusual API performance. Requests could intermittently take up to 10 seconds to complete.
So we started an investigation to determine what caused this erratic API performance.
Our first hypothesis was that base size was the culprit. We ran a benchmark across bases of different sizes, and oddly the 10K base was much slower. Granted, each base had different data in it - but the consistent performance on the other 1K base and 49K base indicated that size wasn’t the issue.
So it must be something with the structure of the base that impacts API performance…
Read the full post to learn what elements of your base cause the Airtable API to slow down.
Apr 30, 2021 09:10 PM
You missed an easy opportunity to make use of Airtables interactive charting apps. :slightly_smiling_face:
But that was an informative read, cheers.
Apr 30, 2021 09:49 PM
This is such an amazing article. Thank you!