Re: Pro*C vs OCI

From: Nathaniel Mishkin <mishkin_at_atria.com>
Date: 9 Sep 1998 12:38:02 GMT
Message-ID: <6t5sra$jq0@bgtnsc03.worldnet.att.net>

>OCI is a native interface with Oracle. Pro*C is the embedded code that
>operate on an Oracle database. OCI is faster than Pro*C and does not
>require any precompilers.

I'm pretty new to Oracle, but I've been writing some test programs to investigate the performance of various operations, and to my surprise, in a simple program that does a loop of SELECTs that return one random row from a table, my Pro*C program was faster (by about 10-15%) than my equivalent OCI program. I do all the OCI setup stuff outside the loop. The only OCI call I make inside the loop is OCIStmtExecute(). I figured this would yield the best performance, but perhaps not.

Anyone have any ideas?
--
Nat Mishkin
Rational Software Received on Wed Sep 09 1998 - 07:38:02 CDT