Re: OCI performance with user callbacks

From: roger <rsr_at_rogerware.com>
Date: Mon, 06 Jan 2003 23:28:09 GMT
Message-ID: <Xns92FB9D821405Brsrrogerwarecom@204.127.202.16>

Hi. Thanks for your thoughts.

I should have mentioned my setup before I suppose...

Solaris 8 single CPU system, Oracle version 9.0.1 Though threaded, my application happens to be "naturally serialized" w.r.t Oracle, so I create the OCI environment with OCI_NO_MUTEX specified.

I'm not sure what 'context switching' you're referring to exactly. The way I see it, I call some OCIMumbleFunction, which executes in the same thread context as it is called from. It may eventually initiate a server request, and so my thread will sleep for a bit while that goes on.

But, I believe that the callbacks would occur before and after any such round trip to the server, and therefore am surprised by the additional overhead they incur.

Pablo Sanchez <pablo_at_dev.null> wrote in news:Xns92FB99911710Cpingottpingottbah_at_209.242.64.107:

> roger <rsr_at_rogerware.com> wrote in
> news:Xns92FB70E521D8Drsrrogerwarecom_at_204.127.199.17:
>

>> Hi. Has anyone using OCI "user callbacks" noticed that the
>> performance of your OCI application drops off *dramatically*
>> when these are used?  Or is it just me?

>
> Roger,
>
> I haven't tried using call backs for the work my company recently did
> (porting OCI 7 to OCI 8/9). I think intuitively, I would expect a
> performance degradation because of the context switching within the
> process.
>
> Is this on Windows or a Unix environment?
>
> Thx!
Received on Mon Jan 06 2003 - 17:28:09 CST