Speed optimization

[Pooja_Kumar]

Thanks @Jeff_Hager and @Eric_Penn for your response & guidance.

[Pooja_Kumar]

Hi @Jeff_Hager and @Eric_Penn since we have 40 sub-sheets in our Gsheet and it is taking time for outputs to reflect back to users when they change few inputs, we were wondering whether Glide App <> Glide Server sync is for all data in all Glide Tables or only for the columns that are displayed/updated. And similarly for Glide Server <> GSheets sync, is it all the tables and rows that get transferred every time?

[Jeff_Hager]

I don’t know the answer to that. It’s probably more a of a limit on Google’s end that data can only synchronize so often. I’m sure there’s rate limits in play somewhere along the line. Like I’ve mentioned several times before, calculations need to use glide computed columns if you want instant results. There’s no way around that. Computed columns run calculations directly on the user’s device, so there is absolutely no delay. Relying on the sheet to handle calculations means data has to sync from app to glide to google and back again. There’s several hops for the data to travel between the app and a couple of servers. I don’t know what to tell you. There will be a delay if you are purely relying on the google sheet to handle all calculations.

At this point, my only advice would be to consider an Enterprise plan so you can possibly gain access to Glide’s API’s that can directly update glide tables. This would probably require Google scripting and/or some integration with Integromat or Zapier to call the API’s whenever values change in the sheet. It still wouldn’t be as instant as using Glide’s computed columns, but might be slightly faster. The other option would maybe be to use the javascript plugin to either run calculations directly in the javascript column, or use it to call API’s in your sheet to get and return results.

Glide table API & curl - what can we all learn together?

[image] @Mark and @david have been busy I use integromat for most of my backend but I’ve hired an engineer to help me out @mubeeniftikhar so we are ready to figure out how to solve my various use cases: how to use an integromat scenario that produces an agent ID and TestFlow ID …. And push that to the Agent sheet, matching against Agent ID (row id) and writing the tfid into ‘current tfid’ programmatically set columns in the TestFlow table to clear all or some valu…

It’s really hard to say what you need. Your current methods and processes are going to introduce a delay, no matter how you cut it. No matter what, that data has to make several hops and wait for the sheet to complete calculations before making those same hops back to the app. You’re not doing the calculations on the user’s device with computed columns, so it’s going to take longer.

You may be better off having a chat with a glide representative to explore your options on a more technical level.

[Pooja_Kumar]

Thanks for your detailed response @Jeff_Hager. We will explore these valuable suggestions.
However what we wanted to understand at this point was, if we change only few inputs from the app, does the Glide App <> Glide Server sync ALL data in ALL Glide tables or only for the cols. that are changed/ displayed on the App screen?
And similarly for Glide Server <> GSheets sync, is it all the tables and rows that get transferred every time or only those that are changed/ displayed?
If above is the case, then size of the entire sheet will have bearing on response. If its only the updated values, then it may not.

[Pooja_Kumar]

And thanks for the suggestion, we will get in touch with a Glide rep to understand the above