Oracle 8i & NT 4.0 ODBC Preformance [message #367767] |
Thu, 30 March 2000 11:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|