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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2002

Added on Sep 26 2002

#odbc, #windows-and-net

5 comments

820 views