I have question about something that had me tearing my hair out for the past two days.
Long story short: specifically over my home network, my connection to our work MongoDB is stupidly slow. Over my home network it takes around 40 seconds to load a page. When I switch to my mobile hotspot for example, it takes around 1 second (it is this fast as well when I go to a friends house with my laptop or use the office network as well).
Did some wiresharking, here is what is happening:
Fast query sniff over my mobile network
Slow query sniff over my home network
As you can see, the query information is sent whenever an SSL packet of length 329 is sent. For some reason, it takes around 40 seconds over my home network to get the packet with that length. Before that, there is a bunch of retransmissions of the same SSL packet that is length 149 which is never sent through a different network.
Here is what the full message looks like (length = 329 in the screenshots)
So the problem is indeed not with the query but with the stuff in between the first tcp hello/query request. As a side note, my home network speeds are pretty solid, its consistently above 150Mbps and pings are snappy.
I tried both wifi and ethernet with similar results. When talked to the ISP they said our building was old and our infrastructure here is sh*tty (yes, this is actually what they said) and there isn't anything specific with our account that would cause something like this. Any help or clues as to what might be a way of going about this would be very much appreciated. Thanks.
EDIT: fiddling with the MTU value on my router had no effect.
EDIT: wrangled pcapng files (5.5.5.5 is the server and 192... is my home desktop)