Re: ORACLE NAMED PIPES versus TCP/IP

jricardo_at_ipb.pt wrote in message <7758gj$6r7$1_at_nnrp1.dejanews.com>...
>
> Can anyone explain to me the advantages and disavantages of using ORACLE
>NAMED PIPES versus TCP/IP in the Client Net configuration ??? What the most
>used configuration TCP or PIPES ????

IMHO you can not really compare PIPES with TCP as you get TCP pipes too. You basically have 2 programming interfaces for TCP, network pipes or sockets. The "nice" thing about pipes (from a porting point of view) that you can pretty much run it on other protocols too like NetBEUI and IPX/SPX. But that's not really the issue. (not even a development one IMO either)

In my experience, based SQL-Server client-server configurations (which defaults to pipes), sockets are a much less of an overhead ito network traffic. SQL-Server's pipes really trash a WAN if your gateways have limited bandwidth. I think we had something like a 20+% decrease in network volume by simply switching SQL-Server and VB clients from pipes to sockets.

Also pipes is not that often used either by networking software. Which seems to indicate that sockets provide a much better option.

regards,
Billy Received on Mon Jan 11 1999 - 07:16:22 CST