Direct connection perfomance

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
mars
Posts: 15
Joined: Tue 14 Jul 2009 13:56

Direct connection perfomance

Post by mars » Fri 06 Nov 2009 15:24

Hello.

We've tested some SELECT-queries under direct connection and under tns connection. Results are disappointing. Same queries under direct connection running slowly in ten times. What's causes of this? Are there any tricks to improve performance in direct connection case?

Thanks

Shalex
Devart Team
Posts: 8085
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 11 Nov 2009 12:15

Please try the latest 5.35.52 version of dotConnect for Oracle. Does the problem persist with the latest version as well? If yes, please send us a project with your tests (include also the DDL/DML script), tell us the versions of your dotConnect for Oracle, Oracle Client and Oracle Server.
We will investigate the issue and notify you about the results as soon as possible.

Post Reply