3 ms·
Had some devs in another country complaining that their database query was taking hours to complete but doing it from a server in the same datacenter took a few
by Hikikomori 2y ago
Had some devs in another country complaining that their database query was taking hours to complete but doing it from a server in the same datacenter took a few minutes. Took some weeks of emails and a meeting or two until they understood that we couldn't do anything, I had to actually say that we couldn't do anything about latency unless they physically move their country closer to us.
- jstanley 2y agoCould you replicate the data to their country and let them run queries locally? Could they run their client from your country and operate the UI remotely? There are more options than moving the country!
- Hikikomori 2y agoI was the network engineer. It was their server and database, I couldn't solve the latency problem for them.
- rodrigodlu 2y agoIt's easier to have an replica. Doesn't matter if it's "realtime" sync or using CDC, from backups, etc. You can even ask one of these guys to do the setup for you. They'll do in a pinch with a happy face. I know because I did.
- Hikikomori 2y agoIt is, but not my problem as a network engineer. We did suggest that though but they refused to believe that we couldn't solve the latency "problem".
- martyvis 2y agoI have been there many times. While the network guy can solve some of the latency in things like TCP handshakes and use compression and caching with magic black boxes you can't fix the actual application query and acknowledgement requirements that might be there.