Edit app interface becomes really slow
My app is connected to multiple (around 10) tables and has around 50 app users in the whitelist. The edit app interface has become really slow, to a point where I cannot really use it anymore. What is causing it to be slow, is it the number of tables/users/formulas?
Any idea what I can do to make it run smooth again?
Is the sitation still the same?
In addition to getting your browser, browser version, and OS, I’d add these troubleshooting steps: 1. Could you try turning off all your browser extensions and seeing if the editor speeds up? 2. Could you open up the browser console (F12 in Windows) and check to see if there are any errors listed?
The thing that really slows down the editor is when there are several hundreds of columns. The Column Structure tab does need to get rewritten (it is the only part of the editor that wasn’t completely rewritten last year).
@Pim_Sauter and @Grant_Stead, could you give us the app names please — we can open them and see what’s going on. As Aleksi said, data volume and whitelist size don’t matter. It is all in the column structure.
Using Chrome Version 63.0.3239.132 (Official Build) (64-bit)
@praveen the slow app is
‘Quote calculator’
Basically it should have nothing to do with the table or user amount. I have editor open with 30 tables and 30 users and it works without any problem. What browser are you using? Have you tried to use another browser? Have you tried to clean the cache? Is everything else running as normally in your laptop/desktop?
@Aleksi_Alkio I am using Chrome and all other tabs are going just fine; let me try Firefox and see what happens
I tested with Chrome and it seems to work as normally.
Okay, I will do some more testing; I was just wondering if the number of users/tables/size of tables should have impact on how fast the edit interface is
Do you have huge amount of data in those tables?
@Pim_Sauter I have the same issue expanding a table or creating a view takes 5-10 seconds… It seems every single click just takes forever…
One of the tables is a survey and has ~150 columns. Not a lot of records in there yet
Hi @Pim_Sauter, Just in case you have not referred this recent informative post on app performance by
@praveen. Please take a look
plus.google.com - Improving App Performance This year, we’re increasing our focus on tools to … Improving App Performance This year, we’re increasing our focus on tools to … plus.google.com
Thanks @Suvrutt_Gurjar, I am reading it now.
@praveen this is mainly about end user experience, if I understand correctly.
Is there any similar documentation on app editor experience? This is becoming really slow for me; the interface becomes laggy and clicking buttons becomes very slow to near impossible.
Yep, and it definitely has to do with the size of the app; small apps are fast to edit, apps with big tables are unmanageable.
My tables are small, but I have like 20 tables all referenced… One of them is a user table so it’s referenced to almost every table… That’s when my app editor gets slow…
Just tested on another machine which is really fast (2016 macbook with 16gb ram) and had the same problem there.
In my experience, the app editor gets slower if the app gets more complex, which can be:
I have not been able to find out what is ‘the worst’
We will investigate the possible reason for this behavior. Grant… what browser are you using? What version?
Thanks @Aleksi_Alkio! Let me know if I can be of any help here, or if you need more info.