RE: is IPC really faster than TCPIP?
- From: "Barr, Stephen" <Stephen.Barr@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 2 Sep 2004 13:48:12 +0100
I'd be really interested in hearing the opinions of others on this - we are
thinking of implementing IPC on the recommendations of Informatica (our ETL
tool). We have a lot of network traffic due to the row-at-a-time processing
in informatica.
Informatica and Oracle are both on the same box.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Juan Carlos Reyes Pacheco
Sent: 01 September 2004 22:24
To: oracle-l@xxxxxxxxxxxxx
Subject: is IPC really faster than TCPIP?
Hi list, Sorry for starting two thread about the same, but I found
Tom Kyte says "well, tuning TCP vs IPC would give you marginal improvements.
http://asktom.oracle
com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6136118136754
but Kenny Smith in Use IPC for local connections, a process can be up to 10x
faster
he says " I've seen a SQL job that runs in 10 minutes using TCP on a local
machine run as fast as one minute using an IPC connection"
But http://searchoracle.techtarget.com/originalContent/0,289142
sid41_gci940662,00.html
So I think the question is not is why ipc is not faster, else is IPC really
faster.
Some experiences please.
Juan Carlos Reyes Pacheco
OCP
----------------------------------------------------------------
To unsubscribe send an email to: oracle-l-request@xxxxxxxxxxxxx
and put 'unsubscribe' in the subject line.
----------------------------------------------------------------
.
-----------------------------------------------------------------------
Information in this email may be privileged, confidential and is
intended exclusively for the addressee. The views expressed may
not be official policy, but the personal views of the originator.
If you have received it in error, please notify the sender by return
e-mail and delete it from your system. You should not reproduce,
distribute, store, retransmit, use or disclose its contents to anyone.
Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.
-----------------------------------------------------------------------
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
Other related posts:
