Re: Which Protocol to use?

Syltrem wrote:
> Both BEQ and TCP should give the same performance, but BEQ for clients on
> the same machine as your db server may be a better choice.
> BEQ is a "more direct" way to communicate. I don't know what principle it
> uses on Unix (OpenVMS is my religion) but if you use TCP you get in
> concurrence with all other TCP traffic. On heavily loaded networks, this may
> impact your Oracle throughput.
>
> Here for local clients I use BEQ, for all others I use TCP.
> I once had a performance problem (in the beginning) and had to set
> TCP.NODELAY=TRUE in PROTOCOL.ORA, but after that I had the exact same
> performance using either one.
>
> HTH
>

Hard to believe, as TCP has all the overhead of communicating over (bad!) telephone lines, whereas BEQ (or IPC, for that matter) does not.

OTOH, TCP implementations differ per platform, per vendor, so your experience may differ from mine.
I *know* IBM had a TCP patch for AIX 4.3.3; for performance reasons.

-- 

Regards,
Frank van Bortel