App is taking too long to Sync and App formula's not working for creating Image URL's

[Yogesh_laddha]

Hi,

I have noticed that a couple of my apps are now taking too long to sync. Almost around 100 seconds.
I also checked in the performance profile but there are no suggestions as well.

This can’t be normal right?
I have lots of other more complex apps which syncs in around 4-6 secs.

I have all the options in Offline/Sync enabled, if that helps.

Also,
In this app, I am using 3 physical columns and 3 virtual columns to compute the URL for the image.
Both the virtual and physical column formulas don’t seem to work. It always ignores the Filename at the end.
Even if I edit the row multiple times, the physical columns are not re-calculated.

The formula I am using is :

CONCATENATE(
“https://www.appsheet.com/template/gettablefileurl”,
“?appName=”, ENCODEURL(CONTEXT(“AppName”)),
“&tableName=”, ENCODEURL(CONTEXT(“Table”)),
“&fileName=”, ENCODEURL([Edited File 1])
)

I even tried to create an action and update the physical columns in the row, thinking that the image name might not be getting stored while saving the form for the first time.
But it doesn’t work as well even though the [Edited File] column has value in it.

I am not sure what is causing this or how to resolve this?

@Steve Can you help?

[Steve]

Yogesh_laddha:

This can’t be normal right?

Depends entirely on your app. Slow sync is almost always due to complex virtual column calculations.

Yogesh_laddha:

Also,

Really better to start a new topic for each problem.

Yogesh_laddha:

In this app, I am using 3 physical columns and 3 virtual columns to compute the URL for the image.
Both the virtual and physical column formulas don’t seem to work. It always ignores the Filename at the end.
Even if I edit the row multiple times, the physical columns are not re-calculated.

Yep, and it’s probably not going to.

Would be nice if you gave us some idea how the “3 physical columns and 3 virtual columns” are involved, as your expression references exactly one column.

[Yogesh_laddha]

Hi Steve,

I understand that the VC affects the sync speed.
But I am not sure if that could be the issue here.
I only have 3-4 virtual columns in a table and there are only 4 tables that have VCs.

I have had more complex apps where I had more than 30-40 VC’s and it still used to Sync much much faster than this.
I think I will try removing the VCs anyway and see if that helps.

For the 2nd question, I am sorry I didn’t create a new thread and didn’t explain it fully.

So I have 3 image columns where the user uploads the image.
Then the 3 Physical columns are to populate the image URL using the app Formula.
The formula for 1st is mentioned below and then I simply replace the Filename with [Edited File 2] and [Edited File 3] for the other 2.

CONCATENATE(
“https://www.appsheet.com/template/gettablefileurl”,
“?appName=”, ENCODEURL(CONTEXT(“AppName”)),
“&tableName=”, ENCODEURL(CONTEXT(“Table”)),
“&fileName=”, ENCODEURL([Edited File 1])
)

For the 3 VCs, I am using the exact same formulas.
I only created VCs because the physical columns were not updating.

All the 3 physical and VCs are of field type Longtext if it helps.

Shouldn’t the physical columns recalculate if an edit is made after the form has been saved?
Or whenever an edit is made to that row?

I hope I explained it clearly. Let me know if you need more details.

[Steve]

Yogesh_laddha:

I only have 3-4 virtual columns in a table and there are only 4 tables that have VCs.

What are the App formula expressions of those virtual columns?

How many rows in the tables?

[Yogesh_laddha]

Hi,
Sorry I couldn’t get back to you on this earlier.

There was one table that had 7000+ rows and 1 virtual column with SELECT expression.
I removed the virtual column from that table and it significantly helped to reduce the sync time.

Thanks for that.

However, I am still not able to figure out why the expressions to Compute Image URL are not working?