DNS is only for name resolution. It doesn't actually affect your internet speed once you have connected to the website you are downloading a page or content from.
However, if you are browsing in firefox and the stage where firefox says something "Looking up
www.dilbert.com" takes a long time, then using google's DNS will help. It won't speed up the actual downloading of the website.