Speed of access: AirTable vs Get From Array vs Sheet in Google Drive

Features
, , ,
1

I’m curious how speed of processing of a scenario is influenced by pulling values from AirTable vs Pulling from an Array/bundle that has been previously pulled from a Google Sheet.
Thanks!

3

Hi @Scott_Swain,

I am not sure what you are comparing? Of course, if the module has to make a request to Airtable in order to process a value, it will take more time than a module that only has to process a value that is already in memory.

Is that your question?

Cheers,
Henk

1 Like
4

Hey Henk -
Yes, thanks for answering and thanks for your clarifying question.
As a 29-year software engineer, I understand that this could be as simple as something like RAM vs HD or RAM vs network access.
I guess (and I apologize for not being more clear before): I’m looking for someone to say more like, “Yes AirTable access would be slower but not very noticeable because caching or something…” or “I only recommend using AirTable for initial pulling data into some local variables because it’s 10x slower…”
So yeah, I hope that is more clear :slight_smile:

5

Thank you for your clarification, @Scott_Swain.

It is an interesting question, although I must say I never bothered to answer it. For me, any delay or speed of an executing is negligible. Only the Teams and Enterprise plans have high priority execution. With plans lower than that, scenario runs are placed in a queue, so there you are at the mercy of the speed of processing on Make’s side anyway. And I haven’t been in a situation where I needed to optimize speed that far, so I cannot help you answer this question, unfortunately.

Cheers,
Henk

4 Likes
6

Actually that is the kind of info I was looking for. THANK YOU, Henk!

2 Likes
7

You can shave a few seconds per Airtable/Google Sheet module by using the Make’s native solution: Data Stores.

For more information, see the Data Store documentation in the Help Center or Make Academy.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

Help Center Basics

Articles & Videos

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!