Re: PRO*C vs. OCI: what is faster ?
From: Michael Krolewski <mkrolews_at_upw.com>
Date: 1996/07/12
Message-ID: <31E6C9C2.18E_at_upw.com>#1/1
Date: 1996/07/12
Message-ID: <31E6C9C2.18E_at_upw.com>#1/1
Tolq L. wrote:
>
> Is it have sense to rewrite PRO*C programs in OCI to increase
> performance ?
>
> Toli Lyssak.
IMHO, the performance difference is not that high. The major performance issue is still the time to get the data. And that is not to improve by writing in OCI versus Pro*C.
The latest versions of the Pro*C pre-compiler does generate better code than before.
Generally, readability for that next change is better in Pro*C than in OCI. Performance inprovements in getting blocks of records or calling the SQL code more judiciously would lead to far higher improvements.
Mike K. Received on Fri Jul 12 1996 - 00:00:00 CEST