Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Cursor fetches slower on 8.1.7 than 7.3.4
Has any one come across this problem, and more importantly can
anyone suggest a workaround. From talking to Oracle 9.2 is not
going to be released until March 2002. Does any one know how
much slower a FETCH is in 8.1.7 than in 7.3.4?
> Slower Performance of Single Row Selects.
> ------------------------------------------
>
> Bug:1238084 - PRO*C APPLICATION SHOWS DROP IN PERFORMANCE AFTER UPGRADE
FROM 8.0 TO 8.1
>
> Due to unforeseen issues when designing the Preocmpiler interface for 8i
using
> OCI it has been found that the performance of single row selects i.e
> EXEC SQL SELECT .... INTO .... FROM ....;
> is much slower in Version 8i and 9i. The amount of degradation increases
with
> the number of columns being selected. This bug requires a large amopunt
of
> recoding in the precompiler interface library and is planned to be fixed
in
> Version 9.0.2 and once fixed it will not be possible to back port the fix
to any
> earlier versions.
>
> Fixed Version: 9.0.2
> Patchsets: Cannot be ported to earlier releases.
>
>
Any help/info would be greatly appreciated.
Michael Lennon
michaell_at_altion.com
Received on Mon Nov 12 2001 - 06:07:40 CST