Extreme Delay in Sync time (Minutes long)

[Rurrea]

The degree of parallelism is high. 

My Order Table: 27K rows, 13 columns

Order Detail Table: 37K rows. 7 columns

Product Table: 42K rows, 11 columns

Other references in Order Table:

Customer Payments, deliveries, warranties, Furniture, and a few others

My Order table: has several virtual columns that may be the main issue, but when removed still extremely slow.

How can i resolve this? App is becoming unusable at this point. 

[Aurelien]

Hi @Rurrea 

Did you try using Security filter ?

it could be the first thing to try, regarding the amount of data you currently have.

For example, about order and order details tables: filtering on last 30 days orders could be an idea. The expression would be:

[TimeStamp]>NOW()-30

Also, about virtual columns: some may be more expensive if you use LOOKUP expression instead of dereference expressions, for example.

Maybe something to look at 🙂

Here are a few tips:

https://help.appsheet.com/en/articles/962230-improving-the-speed-of-sync

[Rurrea]

Yes, definitely using security filters. But that poses two challenges.

1.) Management needs to be able to see all invoices at certain times to resolve issues.

2.) Some of my uniqueid() formulas can possibly risk being duplicated if some data is filtered.

What ideas may you have around that? 

[Aurelien]

1) What about using a table with modular time period for security filter ? If only management use it, that could do the job and allow them to load only necessary time period.

2) UNIQUEID() is virtually impossible to duplicate. I would not worry for this.

For reference:

https://help.appsheet.com/en/articles/2357317-uniqueid