Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: External C Procedures performance
Billy,
0.7 ms is about 245k clock cycle for the mentioned machine, it is way too much. You only need about 20 clock to call a DLL function. This overhead makes external C procedure much less useful.
And why you think that I develope SW for goverment?
WST
"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message
news:apqo1k$7fa$1_at_ctb-nnrp2.saix.net...
> WST wrote:
>
> > I timed an external C procedure call to a do nothing C function.
>
> Developing software for government? :-)
>
> > It takes about 0.7 ms per call.
> > I timed it on a default Oracle 9i instalation on a PII-350 with 320MB
RAM.
> > Is there anything I can tune to reduce this 0.7 ms overhead?
>
> Faster CPU. I can not think of anything else.. those overheads are because
> of pushing and popping stacks and registers and what not. All kernel
> (Oracle and o/s) related. The only way to make it happen faster I would
> think is to make the machine code instructions execute faster - ie. faster
> CPU.
>
> --
> Billy
Received on Thu Oct 31 2002 - 02:52:08 CST