Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: External C Procedures performance

Re: External C Procedures performance

From: WST <me_at_privacy.net>
Date: Thu, 31 Oct 2002 03:52:08 -0500
Message-ID: <apqqqp$431gv$1@ID-127694.news.dfncis.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US