Re: External C Procedures performance

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 31 Oct 2002 10:00:53 +0200
Message-ID: <apqo1k$7fa$1@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:00:53 CST