howdykolache / admin

0 stars 0 forks source link

Extreme slowness in app #47

Closed ezl closed 2 years ago

ezl commented 2 years ago

@niall-p-gray i reviewed this. it works fine. however, as an alternate issue, i'm experiencing extreme slowness in the app. As an example, I timed the response time from pressing "save" to receiving the success message. In 2 trials:

83 seconds 86 seconds

This is unacceptably slow.

--

Additionally, loading pages is very slow as well.

--

a REASONABLE load time is less than 5 seconds. Anything more is unacceptable and we need to fix. This is now the top priority.

A good (and should be VERY achievable) load time is less than 2 seconds.

We need to assess WHY this is happening first. Do you already know?

niall-p-gray commented 2 years ago

I've adjusted the code and load times are much more quickly. It turns out there was a line of code that I must have added for testing that was creating Google Drive files needlessly, and on turning it off the page is a lot less sluggish. I think this was the main reason for the slow loads, but I've also tweaked the formulas used to grab the Airtable data in a way that I think will be a little more efficient. Admittedly the standing order builder is still not super quick, so if still too slow let me know and I can try adjusting the code to improve efficiency.

ezl commented 2 years ago

@niall-p-gray seems to have improved - great fix. :)

will mark as complete and keep our eye on the speed.