Disable Delta Sync for particular Tables alone

[jyothis_m]

Don't know if this Tip is already posted but still if someone finds this useful.

Enabling the Delta Sync Option can significatly improve the Sync Times. However, if the Table contains virtual columns, they are not updated instantly and significant delay is there before VC updates. Disabling the Delta Sync totally for the entire app spoils the benefits provided by this option. Also, as mentioned in the Documenatation, Delta Sync feature will not work for Tables with Security Filter. But what if my Table does not have a security filter.

In one of my apps there are several tables and sync time was high before enabling the Delta Sync option. However 2 or 3 tables had VC which needed immediate update.

So, here is the solution that i found. I made the Security Filter field as TRUE (same effect as blank security filter) and the Delta Sync is disabled for that table alone. All VCs immediately update after sync.

With this, specific tables can be bypassed from Delta Sync so that they update immediately on every sync.

[Steve]

Nice!

[Marc_Dillon]

Hmmm, interesting.

Where in the docs are you finding that delta sync doesn't work on a table with security filters?

[jyothis_m]

Hi @Marc_Dillon 

[Kirk_Masden]

Note that if you look at the documentation on "Delta sync" you won't find this.  AppSheet people: Please fix the documentation.

[Steve]

Attn @lizlynch 

[lizlynch]

@Steve - Thank you for the ping!

@Kirk_Masden - Thank you for flagging this outage! I have added a note that the setting is ignored for tables that use security filters. See Improve the speed of sync.

[Suvrutt_Gurjar]

Good one @jyothis_m .

[OptimiX_XcrY]

Thank you, this is great.

I was tired of manually changing something in google sheet, so I cand trigger the VC updates sooner 🙂

[Kirk_Masden]

Today I noticed this:

Of course, the fact that the Delta Sync option will be ignored for tables that use a security filter is a "feature," not a "problem" in my case.

It is for reasons like this that I have requested that AppSheet allow us to hide "Errors & Warnings" that we don't consider to be problems:

https://www.googlecloudcommunity.com/gc/Feature-Ideas/Silence-or-ignore-specific-warnings-in-editor/...

Otherwise, there's a sort of "crying wolf" problem; we are taught to ignore error warnings.  If you agree, please vote for this.