I'm making a query to the retool db, that looks as fast as I'd expect to actually run the query, but the performance information shows that data transfer is extremely slow: almost 500ms for 1 row. This is on retool cloud, connecting to retool db, so I'm surprised it would take this long.
Thanks for reaching out, @Milo_Watanabe1.
This is a little on the slow side, but roughly in line with the 300-400ms of inherent latency that I typically tell folks to expect when executing app queries. All requests from the client are routed through Retool's backend servers, meaning there's a fair bit of transit involved depending on where you're located.
If you are comfortable giving me the name of the query, I can look up the relevant requests in our logs to see a more thorough breakdown of how that time is spent. 
Hey @Darren - having a similar issue, like we spoke about at a previous office hours.
We have a database replica with AWS that is configured as a resource in Retool. I ran a query on that resource, the first attempt took 11.98s, the second attempt took 4.469s. Our Engineering team ran the same query on the same database through pgAdmin and it took 0.346s.
Could this be an issue with out configurarion in Retool? It's far longer than the 300-400ms of latency you had previously mentioned to me. Thanks!
1 Like