Will my app perform well during peak traffic? Seeking insights (Airtable as data source)

Hi everyone,

I’m developing an app using Softr as a front end and Airtable as the data source. The app serves as both a client portal and an internal operations tool, with 3 user groups: clients, employees, and managers.

Here are the key details:

  • Two pages are the most block-heavy, with 10+ blocks each.
  • I’m optimizing the performance by using tab containers to limit Airtable requests during the initial page load.
  • At peak traffic, I expect around 100 concurrent users interacting with the app (creating, updating, and reading records from Airtable).
  • Given Airtable’s 5 requests per second limitation, I’m concerned about potential performance bottlenecks or errors.

I don’t mind if there’s some delay when loading pages; my main concern is ensuring the app functions properly during high traffic.

Questions:

  1. Will the app handle this level of concurrency without running into errors, considering Airtable’s request limits?
  2. Has anyone built something similar and can share their experience or best practices?
  3. How can I simulate the performance of the app with 100 concurrent users to better understand its behavior under load?

I’d greatly appreciate your comments and insights!

Thank you!

2 Likes