Unfortunately, it's been a while since I was in the OCI innards here,
but I recall that there was an issue where the OCI 7 approach to
prefetching did not work with Oracle 9 databases. This made
applications send a separate network request for every row, unless the
client application was specifically written to do array fetches (which
most ODBC applications are not designed to do).
Distributed Database Consulting, Inc.
On Behalf Of Smith, Ron L.
Sent: Wednesday, February 16, 2005 4:35 PM
Subject: Oracle 9i performance
We have an application running on an NT server using an Oracle 7.2 V2.5
ODBC connection to talk to a new 9.2 database on a Linux server. The
application transfers a lot of data back and forth. The performance is
pretty slow. Could it be caused by the old ODBC and SQL*NET on the