Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Program delays (Pro*C)
You want to be using 'BEQ' or 'IPC', probably 'IPC', especially if the
program is running on the server where the DB resides. What this
means is that your program would not be using TCP and not creating a
lot of net traffic. IPC stands for Inter Process Communication, so,
instead of talking(so to speak) to the DB via TCP, the program would
be talking directly to the DB processes, well, there's more to it than
that. Also, how many records are being commited here? How slow is
the commit? You may want to think about save points or intermittent
commits in the prog.
HTH,
Pete's
"Dilan" <dilan_at_example.net> wrote in message news:<w0Pwa.41$s14.43700_at_news0.telusplanet.net>...
> Hi,
> I am starting to look at this from the Net8 side of things. I have found an
> article on Metalink (Note:73929.1) that comes close to describing a solution
> to my problem. But we are using tnsnames.ora file to establish our
> connections. So whatever these "bequeath" protocols are I hope we are not
> using them. Is there a way to confirm this?
>
> thanks
> dilan
>
>
>
Received on Fri May 16 2003 - 08:52:39 CDT