SQLFetch() very slow with Oracle

From: Mark Ferreira <u1581274_at_site.uottawa.ca>
Date: Wed, 28 Jul 1999 00:27:47 -0400
Message-ID: <379E86C2.5AA3E5D8@site.uottawa.ca>

I am using the Microsoft Driver for Oracle and the ODBC API.

I'm having trouble with SQLFetch() after a call to SQLTables() or SQLPrimaryKeys(). Actual calls to SQLTables() or SQLPrimaryKeys() execute without problem. It is the first call to SQLFetch after either SQLTables or SQLPrimaryKeys which takes an extremely long time to execute. It is so slow that a program which takes 2 minutes to execute with MS SQL Server now takes more than 45 minutes.

Note that a calls to SQLFetch() execute quickly after a call to SQLTables().

Any ideas? Has anyone experienced similar problems?

Thanks in advance,

Mark Received on Tue Jul 27 1999 - 23:27:47 CDT