# Speed optimization

**URL:** https://community.glideapps.com/t/speed-optimization/30978
**Category:** Ask for Help
**Created:** [August 26, 2021, 9:21am UTC](https://community.glideapps.com/t/speed-optimization/30978 "2021-08-26T09:21:52Z")
**Posts on this page:** 1
**Showing post:** 23

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 6, 2021, 5:07am UTC](https://community.glideapps.com/t/speed-optimization/30978/23 "2021-12-06T05:07:52Z")

</div>

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.

> [@rocket Glide table API & curl - what can we all learn together?](https://community.glideapps.com/t/glide-table-api-curl-what-can-we-all-learn-together/34054):
>
> @Mark and @david have been busy star2 I use integromat for most of my backend but I’ve hired an engineer to help me out @mubeeniftikhar slight_smile 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.

---

_[View the full topic](https://community.glideapps.com/t/speed-optimization/30978)._
