I made a dashboard for my client, initially the data is not that much but by time data volume increased and that made my dashboard load slow. PostgreSQL queries are getting timed out, im guessing increasing timeout duration is not a solution.
Hey @Prafful_Choudhary,
Thanks for reaching out to the Retool community.
We have this page here which walks through some best practices to help prevent apps from being slow. --- Web app best practices | Retool Docs
The main key things to try first would be reducing the payload for any large queries that are coming in. You can then work through optimizing any calls, paginating the data to help fetch data in smaller batches, leverage caching, etc.
There are a lot of things on this page and I would recommend reading through it and seeing if any are helpful.
If there is a specific piece of the app that is slow and you want additional help with, just let me know what it is, how its configured, what the dataset looks like, and I can try and provide some tuning help.
Looking forward to hearing back.
Regards,
John | Retool Support