Hi, I noticed many times while running a retool app that It takes a lot a time to load the app all queries that are on page load are continuously running and takes a lot of time and some of the queries are showed as its running successfully but it can't return anything even the simplest query to get all data from table. And the other while thing while building the app if I drag a component and want to paste on a specific place it acts like the component is stuck while moving. This happened with me and my team member since 1 month
Hello @afaq_mehmood!
Are you self hosting Retool or using the Cloud?
Have you checked your browsers network tab to see what the request and response time of your Retool apps are and if these are succeeding?
Have you benchmarked your wifi and network connection for other applications to confirm that Retool is slower than other similar programs?
Hi @Jack_T I am using the cloud and the response time of queries run on page load is about 2- 3 minutes. Some how I realize that when I drag a component for drop on main screen the component is stuck and takes a lot of time to place on the screen.
I also checked that all other platforms that I use are working fine based on same network connection
Hi @afaq_mehmood I am sorry to hear that the app and the queries are running so slowly.
What are these queries getting on page load?
Are you querying a server that is near to you? Or Retool DB?
If you can share the retool console I might be able to get some more clues as to why these queries are going so slow, my initial guess was they were getting thousands of rows of data and we do have resources on our docs for query and app optimization using server-side pagination.
Also if you could share a JSON export of your app I can try to clone it and see if there's anything I notice that could be slowing it down.
Another possibility if you are not fetching a large amount of data could be distance to Retool server 
In which case, self-hosting retool has been known to greatly improve performance time as you are able to better connect to and manage your own server 
Same! It happens few times per week. Can you please explain why queries running 2-3 minutes or even get timeout, when sourse is working , i send queries to my mongo db dirrectly and all works good. Rettol DB also take too many time to responde. Why it happens, pls help.
I am also experiencing this right now over the last ~45 minutes or so. It appears to be an outage that is not being reported on Retool's statuspage (https://retool.statuspage.io/). Simply loading the retool dashboard page listing our apps, etc. (your-hostname.retool.com) took 21 seconds -- this has nothing to do with any code I am running (though attempting to run a simple code block inside a workflow will throw errors)
1 Like
Hi all. Meet an issue that happens few times already. Suddenly all my apps stop retrieving data from any sourses. All queries to mongo , retooldb, gs so on either take 3-4mins or timeout. THen after 20-30 mins all become good.
Hey all - thanks for reaching out! 
We have eyes on a bunch of different metrics related to our cloud infrastructure but it's not always clear how each translates to the user experience. This kind of proactive communication helps us to better correlate server activity with real-world performance impacts.
The behavior you're describing definitely sounds like latency to the primary cloud database, given that it manifests both in an app and on the Retool dashboard. It may or may not be related, but we have been tracking increased CPU usage for that database cluster and have a remedy planned.
Given the fact that these issues tend to be transient in nature, it's super helpful if you can profile the behavior when it happens. The best way to do this is by capturing network traffic as a HAR file and by generating a performance profile.
I notice this too, usually on Wednesdays. Could it be that there are cloud releases happening on those days, causing the infrastructure to experience heavy load?
That's a really interesting observation, @LinoPino! It's certainly possible. 
We're currently releasing cloud updates as many as 3x per week, depending on the presence of any blocking issues. I'll pass this observation on and pay close attention to our dashboards next Wednesday!
1 Like
I’ve observed that it takes more than 2-3 minutes to delete a component, and the overall app performance has become extremely slow. While debugging, I noticed that a few unused components linked to a particular action are throwing errors due to invalid inputs. Could this be contributing to the performance issues?
Is there anything I can try to improve performance, aside from breaking the app into smaller parts? Any guidance would be greatly appreciated.
1 Like
Hey @Kashizu_Doto! Welcome to the community. 
It definitely shouldn't take that long to remove a component from the canvas. That kind of degraded performance definitely suggests that either you have some super expensive queries running in the background or the app's dependency tree has become too unwieldy.
One way to address the latter is to break the app into smaller parts, as you mentioned. The other thing you can do that touches upon both pain points is change the run behavior of expensive queries to "Manual":
Doing so does require a little more work, but it can make a difference if you prevent that query from running, as a result. Along the same lines, you can disable queries under certain conditions in order to ensure they don't run with invalid input:
I ran into a severe case of degraded performance recently that was ultimately caused by a query running a diff function on undefined, which could have been easily avoided with this strategy.
I hope those pointers are helpful!
Facing same issue. All apps, home page, forum - everything super slow. Why it happened each 2 weeks, why you can`t do something with it? If you do some server work - why you never email admins about it.
1 Like
Thanks for letting us know, @nekitdar! We will generally update our status page whenever we detect or anticipate significant service disruptions. There is an upcoming server maintenance this weekend, for example!
I mentioned this above but will reiterate:
My inbox is always open if you want to DM me with logs or performance profiles, which I can pass on to the performance team. 
1 Like
8 posts were split to a new topic: Significant app slowdown when editing with debug window open