ODBC Performance (Lousy)
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