Results 1 to 3 of 3
  1. #1
    matt Guest

    Answered: TCPIP vs Named Pipes

    I have an ADO client (VBscript running under IIS) connecting to SQL Server 6.5 over a LAN. I run a SQL query which returns a fair amount of data, and if the client is configured as TCP/IP, the query takes about 3 times longer that if I use Named Pipes for the connection. TCP/IP is supposed to be faster.

    Any ideas?

  2. Best Answer
    Posted by Neil Pike

    "Named-pipes (over IP) is probably using a larger physical network packet size. A network trace would show what is going on.

    Neil Pike MVP/MCSE.
    Protech Computing Ltd"


  3. #2
    Neil Pike Guest
    Named-pipes (over IP) is probably using a larger physical network packet size. A network trace would show what is going on.

    Neil Pike MVP/MCSE.
    Protech Computing Ltd

  4. #3
    Zhong Yu Guest
    Which version of ADO are you using? Could it be possible that you are having TCP/IP problems while named pipes is using netbios as underlieing protocol.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •