Accessing Oracle much slower than SQL Server

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
bolek75
Posts: 16
Joined: Mon 10 May 2010 08:58

Accessing Oracle much slower than SQL Server

Post by bolek75 » Tue 07 Sep 2010 12:42

In my winform app using EF4 and dotConnect for Oracle I am switching betwenn SQL Server 2005 and Oracle 10g Express Edition. I am using 2 separate EDMX. I noticed that the performance on the Oracle DB is worse than on a sql server.
E.g. loading my master object plus details in my winform takes 700 msec on sql server, the same operation takes round about 3000 msec connecting to the oracle database.
Does anybody have some general hints on this problem?

Cheers
bolek

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 07 Sep 2010 14:19


Post Reply