Home » RDBMS Server » Networking and Gateways » Oracle 8i & NT 4.0 ODBC Preformance
Oracle 8i & NT 4.0 ODBC Preformance [message #367767] Thu, 30 March 2000 11:38 Go to next message
danp
Messages: 4
Registered: March 2000
Location: Birmingham
Junior Member
Client: NT 4.0, sp5, MDAC 2.1 (6/4/99), MS Oracle driver v2.573.3711, Oracle ODBC driver v8.0.5, & Oracle client 8.0.5

Server: NT 4.0, sp4, Oracle 8i Server v8.1.5

I'm accessing oracle via third party software and an ODBC connection. The performance is pretty slow, a select of about 50 rows takes 15 sec using the MS driver. The Oracle driver takes almost twice as long. When I use Oracle ODBC test or MS Query the select is almost imediate. Does any one have any sugustions on how to speed up my connection?? Server or Client side?? Test i can run to determine the problem??

Thanks,
Dan
Re: Oracle 8i & NT 4.0 ODBC Preformance [message #367806 is a reply to message #367767] Sat, 26 August 2000 23:45 Go to previous message
Shirley
Messages: 8
Registered: August 2000
Junior Member
Not sure if this helps; I ran into it while searching for answers to my own issues.

http://www.orafaq.com/faqnet.htm#PERFORM
Previous Topic: SQL Advice
Next Topic: Trouble between Oracle 7.2.3 and Oracle 8
Goto Forum:
  


Current Time: Fri Mar 29 08:39:38 CDT 2024