we are a heavy Appsheet User since 3 years and generally have built kind of a “big App”.
A problem which until now only occured for Admins (See all tables) was that sometimes the App won’t start, but loads, reloads, loads, reloads,… By logging in and out often the problem was solved. Sometimes even a complete deleting and reinstalling was necessary (iOS).
Now it starts to affect our employees in the field. They start recognizing the problem and since they do have frequent customer contact, it influences their work and frustrates, because they nearly need to do the login/logout workaround a few times in a hour.
What is the reason behind it and how can we solve it? Since it only appears to some (hypothesis: Only the ones, who see much data), we cannot pinpoint it.
Never heard of any such issue, but performance issues on large old apps are mainly due to number of records being built up, so you should try using more strict Security Filters to limit the records.
thanks for your reply. We have been able to pinpoint it. We have 66 users and did not have that problems before even though we have chunked our “big” sheets apart into smaller ones, which should make it better.
Nearly everyone with iOS is affected. No one with android. After reinstalling it works for hours or days before it shows same behavior again.
I can confirm that my clients report similar problems with iOS only as well. It is a big issue now. Could someone please take a look and let us know how to resolve this issue?
Thanks in advance
Hi @Diether61, how is it on your end? Did it start working? One of my clients is still affected, and support is looking into it. However, I am wondering if they provided you with a solution that worked?
Its very slow loading today for me. Just started building a couple of days ago and have less than 10-15 tables with no data, no formulas that effect loading time.
Hey Mateo, unfortunately not. Suppport did not really help but told us that we need to cut down tables and stuff. I do not really get it since there is not really a way to know when a file is too big. And it works on android, so imho it is a architecture problem of the iOS App…
On my end, we finally made it work, and I forgot to leave a comment here.
The problem was a heavy image (~15 mb) that was used for UI enhancement. We converted that to .webp and now host it on our server, and use the direct URL to fetch this resource.
I can confirm that the problem here is almost entirely due to the compressed app size.
On iOS, caching works differently than on Android, and the problem is that there is no way to monitor if we are hitting the threshold except when the application fails to load or loads endlessly.
Quick and easy tip from me - make sure you do not have any large files being downloaded, and the truth is that using security filters is a good practice. When you build a mobile app in a modern way, you do not fetch all the data at once, but you do it upon different user requests, like going to “users view” - this triggers the backend function to get the users or takes the data from the cache, etc. In AppSheet, we do not have that ability. That is why we should limit the data as much as possible, in my opinion.
BTW, it would be a great feature if we could, let’s say, control the queries and when the data is being fetched on the Enterprise plan
