Iโm finished with my first app, and Iโm noticing loading times varies very consistently. 8-10 seconds OR 24-30 seconds.
Is this normal behavior?
Could that just be a sync upon initial loading of the app for the day/time-period, versus syncing during use?
Check your performance profile here:
Itโs in the performance profile Iโve checked it. Iโve started the app from scratch. Itโs actually somewhat slower on PC than on my cellphone with 4G+. (And my PC has 500 mbit connection.)
It is also not the same sheet that takes a long time each time. Sometimes itโs the largest that takes 12 seconds (it usually takes 1,3 seconds) other times itโs a sheet with 8 cells that takes 8 seconds.
Generally, no - load times should not be double like that. Youโll have a range like you have, maybe anywhere from 8-15 seconds is a window that I would say.
I would expect it might be a transient thing, perhaps internet traffic or something. Serve loadโฆ
Now if it continues to vary wildly like that, you might reach out to support@appsheet.com - might be a server optimization issue.
Thank you for your kind reply and insights.
Iโve contacted support, and Iโll leave an update here when I get some answers.
For my current project, I average between 45-50 seconds flat. But I do have a VC calculating a dynamic SVG image with embedded Base64 font for 3000+ rows sooooโฆ That ainโt getting improved any lower. Luckily everything else I do to the app doesnโt increase the time, since the app can do the rest of everything in parallel to the SVG calculations.
Eventually the sync time wonโt matter at all because Iโll be avoiding full syncs completely - outside of initial load or accidental presses of the sync button, since I donโt think I can hide it.
ut I do have a VC calculating a dynamic SVG image with embedded Base64 font for 3000+ rows sooooโฆ
Wow!
It matters to me, because I will eventually have around 60 colleagues using it in the field. Staring at the loading time for 30 seconds is not a good UX, and it will surely backfire on me.
Thank you for the input, it really shows how different our usage needs are.
Is there no way to help reduce this load? Are the images truely unique and need to be generated fresh each time, or could you save a version of each different state and simply use those instead?
They arenโt necessarily all unique. However, they could be. The point being I wanted them to be completely dynamic to the data.
Anoher thing you might consider checking is any spreadsheet formulas; this includes:
Having any of these things on your g-sheet will cause a slowdown, itโs best to steer clear of any spreadsheet fanciness - at least in the sheets holding your data - and just think about the spreadsheet as just a data storage place. (Aka: like a database table, it just holds data.)
I think Iโve followed every guideline there is. Spreadsheets are good, no formulas. A few Ifs in appsheet.
My problem is that randomly, it switches between taking 8-10 seconds to sync OR 24-30 seconds. Not 12 seconds, Not 15 seconds, Not 20 seconds.
The only thing I can think of is that my sync when it is 24-30 seconds is not being prioritized by appsheet server.
Iโveโฆ never really seen anything like that from AppSheet
I know thereโs something about that for business license users. But I wouldnโt think it would be that much of a difference.
Iโm on AppSheet all the time, and I donโt have a business license, and never see sync times vary like that.
User | Count |
---|---|
18 | |
11 | |
7 | |
5 | |
5 |