This works fine IF your ISP's DNS is slow. Let's say it took your ISP DNS 0.1 seconds to reply. The human threshold for detecting delays is in the 0.02 and up range. Anything quicker and most humans think it was instant.
So if your ISP DNS response time is sub point one second then using another DNS may have no payback.
Bob
I read an article about a service called OpenDNS where you could speed up internet performance by changing the DNS settings from your ISP default DNS servers to the OpenDNS servers.
I tried it by changing my DNS settings on my Belkin wireless router only, not on the actual PC's.
The only adverse effect I've seen is an error I received in updating AdAware software. I had to put the old DNS settings back in place and then the update worked fine.
I can't really say if my internet is faster now or not.
Anyone have any opinions on OpenDNS?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic