Edit app interface becomes really slow My ap...

Pim_Sauter
Participant IV

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?

0 30 1,396
30 REPLIES 30

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.

Pim_Sauter
Participant IV

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?

Pim_Sauter
Participant IV

@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.

Pim_Sauter
Participant IV

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โ€ฆ

Pim_Sauter
Participant IV

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

Pim_Sauter
Participant IV

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.

Pim_Sauter
Participant IV

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โ€ฆ

Pim_Sauter
Participant IV

Just tested on another machine which is really fast (2016 macbook with 16gb ram) and had the same problem there.

Pim_Sauter
Participant IV

In my experience, the app editor gets slower if the app gets more complex, which can be:

  • More fields in a table - More tables - More table refs

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?

Pim_Sauter
Participant IV

Thanks @Aleksi_Alkio! Let me know if I can be of any help here, or if you need more info.

Guysโ€ฆ what source are you using and what browser version, thanks

Whatโ€™s your user ID number?

grantstead@steadglobal.com (GOOGLE) Account ID: 297211 appName=EcolCork-297211

Iโ€™m on Chrome, and itโ€™s up to dateโ€ฆ Really most all of my apps are very slow in the editor, I have started to believe this is just normalโ€ฆ

Grant - it takes maybe half a second at most to open views in your app for me, so it might be something going on with your browser or computer. Can you try the troubleshooting steps I mentioned above?

@Sarah_Gould_AppSheet Whoa! I disabled all of my extensions, and itโ€™s all awesomey now! Now I need to figure out the culprit!

I did F12 and I found this thoughโ€ฆ Failed to load resource: the server responded with a status of 404 (/offsite/notFound.jsp) https://a20098.actonservice.com/cdnr/cid2/acton/bn/tracker/20098

Great! The error looks like it might be from one of your extensions, I donโ€™t think that url if from any service we use.

Pim_Sauter
Participant IV

Account ID: 486024

Pim_Sauter
Participant IV

Turning off extensions definitely helps, thanks @Sarah_Gould_AppSheet

@Pim_Sauter crazy right! Like what!?

You can try turning the extensions on one-by-one to see which extension is causing the slow-down.

Some extensions run scripts on the pages youโ€™re looking at, which could interfere with our own scripts - but this is certainly not always the case. I have several privacy- and security-related extensions, but they donโ€™t seem to slow down AppSheet.

Pim_Sauter
Participant IV

@praveen would it improve if I have 5 tables with 20 fields versus 1 table with 100 fields?

Top Labels in this Space