DNS translates the address you type into an IP address on the internet. If the server is slow, it can take longer for that translation to happen. Other that that, it shouldn't affect your speeds too much. I personally use 4.2.2.2 and 4.2.2.3 for my DNS servers. I'm also on Comcast.