App sync is very slow: up to 60 seconds.
Is there a reason to? Did I made the app to big/ to much formulas/ โฆ Or is it the amount of data through google sheets that is slowing down the app sync?
Thx Bram
Have you checked the performance profile? help.appsheet.com - Performance Profile
General performance info here: https://help.appsheet.com/performance-scale-reliability/performance/introduction-to-performance-in-a... Performance Profile help.appsheet.com
Hej Sarah โฆ
Iโve had a look to the performance profile and I see that itโs the virtual columns who takes a lot of time.
In these columns I make a sum of values of other columnsโฆ
Is it better to eleminate this kind of sums?
Bram
This is the sum Iโve made: =Sum(Select(Registration[RDV], AND(USEREMAIL()=[Usermail], [Annรฉe]=2017)))
If you have a lot of data, have a virtual column go through every row and perform a calculation can take a while. You might be able to speed things up if you can create a Slice instead of using a SELECT expression - that way the rows are pre-selected, and your sum only needs to run on the relevant rows.
Is it possible to make a sum formula in a slice?
Do you mean to make the sum in the basic table and than filter through the row filter condition of the slice? But than the sum is not only running through the relevant rows.
Thxโฆ Bram
Sorry, I wasnโt clear: you could make a slice with the condition youโre using in your select expression: =AND(USEREMAIL()=[Usermail], [Annรฉe]=2017). Then your SUM expression would be something like =SUM(Registration_Slice[RDV]).
Thx a lot Sarah โฆ
I think this is part of a very good solution for me.
I tried this out but get this error:
See picture โฆ
The problem is that I donโt find the expression mensionned in the error?
Thx Bram
Iโm sorry Sarah โฆ I did something wrong! Now Iโve got it โฆ
Thx a lot! Bram
โExpression appears to be part of a cycleโ happens when you have expressions that refer back to themselves; for example if a column with an expression gets a value from another column, which in turn gets a value from the first column, it creates an infinite loop. It can go through more steps than this, though, making cycles extremely tricky to unravel.
In your case, though, it might be simpler than that. It looks like [Lieu]=[Lieu] should maybe be [Lieu]=[_THISROW].[Lieu]
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |