Retool Location Based Request Latency

[retool_lum]

I have a query that occurs in my Retool application that takes ~2 seconds when I'm at my office. When i'm at home it takes ~15 seconds. The query (as shown by chrome dev tools) is less than 1MB, so it shouldn't be the size or internet speed. When i run the exact same query directly on my DB at either location it takes ~1 second. The DB is hosted by GCP.

Why would the query be so much slower in a different location? We've seen this deviate between fast and slow with multiple people on the team based on their location.

Has anyone else seen this happen?

[Jack_T]

Hello @retool_lum,

Apologies for the issue with the latency. That is very odd that there is such a dramatic difference

In the side panel, are you able to share a screenshot of the query in the two different locations when you mouse over it?

It should show a breakdown of how long different steps in the query process are.

Let me double check with our performance team to see if they have any ideas on what else we could test.

Are you self hosted or on the cloud? If you are on the cloud, we should be able to look up the query runs based on the x-request-id from the chrome inspector panel.

Then we can look at how our cloud servers are responding to the request and see if this delay is server side or not.