Slow performance on data fetching

[ruby river]

I have a simple app with a database of only 2 tables.
In the app, the left is a list of campaigns and on the right are the campaign details.
Whenever one of the campaigns are being clicked, it simply runs a database query on the details table and populate it.
What we have noticed is when we switch between campaigns, the data table and some other fields will show a loading animation. After that, it will still show the details of the previously selected campaign. Then, only after a few seconds, will the proper data be shown again.
Would like to ask if there is anyway to improve the performance on this? It now feels sluggish.

[hexed dawn]

Hi There!
Thanks for reaching out to us. One of our engineers will be with you shortly.

If you are stuck with an issue/error, please help us with following information.

1. Which version of Appsmith are you on?
2. Provide screenshots/screen recordings of the original error/code snippet.
3. Add details about your use case and provide steps to reproduce the issue, if
   possible.

[hexed dawn]

Hi! Can you share a screenshot of the onListItemClick event of the List
widget?

[ruby river]

This is the onListItemClick on the list widget

and this is the data for the table

and the query itself

[hexed dawn]

Thanks. Give us some time to check this and get back.

[hexed dawn]

Would you be able to share the performance profiles for this action? Here is our
guide -
Slow app loads -
https://www.notion.so/appsmith/Profiling-app-load-time-3a0986a001d049bcb422eb42776f6f19
Slow action trigger -
https://www.notion.so/appsmith/Profiling-an-action-in-chrome-dev-tools-9db5cae117f1446fbf67251ad7bb55f9
[https://www.notion.so/appsmith/Profiling-an-action-in-chrome-dev-tools-9db5cae117f1446fbf67251ad7bb55f9]

[celest saffron]

Hi @ruby river , From the video the UI updates appears to be reasonably fast, but showing that stale data is kind of annoying.
I have created an issue for it
https://github.com/appsmithorg/appsmith/issues/18983

If you feel the the app is slow, except for the above issues, please share the profile requested above.

[ruby river]

Hi, thanks for the reply. I did a profiling on a few clicks of the List widget. Here is the file https://we.tl/t-HUFnBS2aW6 (since discord does not allow me to upload large files).
I understand the issue is already flagged on github. But right now, as a work around, are there any workarounds I can do to eliminate the issue? e.g. I have a modal acting as a global blocker with a progress bar. I can activate that while data is being loaded, but is there any event that I can be notified when data is ready to actually disable the modal?