Re: Any ODBC and performance issues

On Wed, 31 Jan 2001 20:26:44 GMT, buckeye714_at_my-deja.com wrote:

merant.com

>Scenario: Third party application. Run's on Windows (Various
>versions). It was written for MS Access. We use Oracle 8.1.6 on
>Solaris. (The vendor modified the code for use with Oracle). A process
>that reads and updates 32,000 records takes 32 hours to run. Vendor
>says it runs fine with Access. I have monitored the database and it is
>running well. Buffer Cache, Dictionary Cache and SQL cache hit ratios
>are all above 98%. No I/O problems. No wait events.
>
>Desired: Information on possible ODBC problems. We are not
>experiencing network problems. The dml is using indexes as expected.
>The transactions don't take long on the database side. I would like to
>rule out the ODBC connection as the problem, but have not worked with
>ODBC very much. Can any one recommend a source for information on ODBC?
>
>Thanks in advance.
>
>Patrick
>
>
>Sent via Deja.com
>http://www.deja.com/
  Received on Thu Feb 01 2001 - 07:18:06 CST