With Microsoft playing musical chairs with its default behaviors under MDAC, Web application developers building for the IIS (Internet Information Server)/ASP (Active Server Pages) platform will need to take greater care when updating core OS data-access components on existing servers. Microsoft's decision to change the default behavior of the Network Library parameter in MDAC 2.6 and MDAC 2.7 will force developers to make a conscious choice regarding which library to employ. TCP/IP (the new default) is faster than Named Pipes (the old default), but it also consumes more CPU cycles per transaction, and the processing overhead that can lead to scalability problems down the road.
Article Link.