search

appsmithorg / appsmith

Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
https://www.appsmith.com
Apache License 2.0
34.52k stars 3.72k forks source link

Fix Slowness/Failure to load Integration API Actions on Saas Integration Manager. #10909

Closed felixsuarez0727 closed 2 years ago

felixsuarez0727 commented 2 years ago

Current Behavior

The API Manager page takes more than 2 minutes to load its contents and most of the time the API Actions Table won't load it's contents.

This happens on the following environments:

Steps to Reproduce

  1. Go to: https://app.appsmith.com/applications.
  2. Click Edit on the SaaS Integration Manager.
  3. Click on View API for the Twilio Integration
  4. Wait up to 2 minutes for the whole page to load (this is the problematic behavior)
  5. The page contents will load, but the REST APIs table won't load its contents unless you click on the refresh button and wait a little more.

Video

Environment

Production

Version

Cloud

felixsuarez0727 commented 2 years ago

Backend(Guess): Noticed on meetings that when you guys use the SaaS Manager, it loads significantly faster. Even though using Chrome instead of FF helped, this feels like it's taking a while to get the resources from the server to the client.

felixsuarez0727 commented 2 years ago

Noticed that on other computers the load time is faster. For this reason, the following test is proposed, in which the different times it takes to perform a process are compared to analyze how it behaves in different environments.

Steps to reproduce the test

  1. Go to https://app.appsmith.com/applications
  2. Start the chronometer and select edit in Saas Integration Manager

imagen.png

  1. Select the Twilio Integration (View API) imagen.png
  2. Update the table, select LIST_MESSAGE, and select Dynamic Variables. imagen.png
  3. When Dynamic Variables finish, stop the chronometer.

Note: fast.com was used for speed tests

Results

ID Test Browser CPU RAM Computer Model Time Operating system Internet Speed
1 Chrome (Version 98.0.4758.80) Core™ i7-5500U 8 GB DELL Inspiron 15-5558 00:38 s Ubuntu 20.04.3 99 Mbps
2 Firefox (Version 97.0) Core™ i7-5500U 8 GB DELL Inspiron 15-5558 01:16 s Ubuntu 20.04.3 99 Mbps
3 Chrome (Version 98.0.4844.51) Core™ i5-7200U 12 GB DELL Inspiron 14-3467 00:36 s Windows 10 99 Mbps
4 Firefox (Version 97.0.2) Core™ i3-8109U 8 GB Intel NUC8i3BEH 01:23 s Windows 10 79 Mbps
5 Chrome (Version 99.0.48) Core™ i3-8109U 8 GB Intel NUC8i3BEH 00:46 s Windows 10 84 Mbps
6 Chromium (Version 99.0.48) Core™ i3-8109U 8 GB Intel NUC8i3BEH 00:33 s Windows 10 78 Mbps
7 Chromium (Version 98.0.47) Core™ i5-2520M 8 GB Lenovo x220 00:59 s Debian 11 81 Mbps
8 Firefox (Version 91.6.0esr) Core™ i5-2520M 8 GB Lenovo x220 02:50 s Debian 11 61 Mbps
felixsuarez0727 commented 2 years ago

Overall, if the time it takes to complete these steps is around 30 - 40 seconds, then the experience is acceptable. But, if completing these steps takes more than 01:00 s, the feeling of slowness is affects the user experience.

Setting aside the fact that using a Chrome-based browser always provides better responsiveness than Firefox (by a significant margin), we could conclude that the performance of the SaaS Integrations app is within range if a computer with good specs (modern CPU) is used.

Since this is related to the SaaS Integration App, and it's clear that this is mostly related to client-side factors, I would advise to close this issue in favor of #8639 and all the other efforts to improve the performance of Appsmith in general.

prapullac commented 2 years ago

Closing the issue as it is working as expected