Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC Performance (Lousy)

199024Sep 26 2002
We have written an ODBC application that runs on SQL Server, Oracle and DB2 (mainframe). SQL Server is far and away the fastest...DB2 is pretty good but Oracle (8i on NT) is painfully slow. One screen refresh takes 1 second on SQL Server and 45 seconds on Oracle with identical data (total DB size is 1GB). Statistics have been run on the database so that is not an issue and all primary keys and indexes have been compared and are identical as well. We've tried the native Oracle ODBC driver 8.1.7.7 and found it to be almost too slow to use. The 45 second time is with DataDirect 4.1 Wire driver for Oracle.

Is this typical Oracle performance with ODBC? Would 9i be any faster? The server we're using is a single 1Ghz processor box. Does Oracle need multi-processors to be usable? From what we've seen and heard Oracle on NT is not ready for "prime time".

Has anyone else experience similar performance problems?

Thanks!

Lon Diehl
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2002
Added on Sep 26 2002
5 comments
814 views