OCI8 Perfomance Problem!

From: George Mikeladze <gio_at_omega.ru>
Date: Fri, 21 Aug 1998 14:14:14 +0400
Message-ID: <6rjh1p$55p$1@storm.comstar.ru>

Hi ALL!

DOES AnyOne Have Such Problem???:

We have ported application from OCI7 to OCI8 - and there is significant slowdown!

So I have done tests:

OCI7 Execute "select 1 from dual" 1000 times using oexfet(). oparse() was called only once. TIME=0.5 sec

Oracle TRACE (tkprof) tells that Oracle8 Server took 0.5 sec to do this.

2) OCI8
Execute "select 1 from dual" 1000 times using OCIStmtExecute() using iters parameter =1, so no more fetching is required. OCIStmtPrepare() was called only once.
TIME=3 sec

Oracle TRACE (tkprof) tells that Oracle8 Server took 0.5 sec to do this. SO WHERE ARE THAT 2.5 SECs???

After tkprof-ing I found that oracle is parse-ing only once in both cases. But! repeating case 1) with OCI7 and parseing before each execute gives also 3 sec!

We use same LIB and DLLs for both cases. Tests are run against local Oracle8.0.4 on WinNT4 on Dual PPro200+256Mb RAM+RAID. Thanks in forward!
George Mikeladze. Received on Fri Aug 21 1998 - 05:14:14 CDT