Accessing Oracle much slower than SQL Server

Accessing Oracle much slower than SQL Server

Postby 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
bolek75
 
Posts: 16
Joined: Mon 10 May 2010 08:58

Postby AndreyR » Tue 07 Sep 2010 14:19

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


Return to dotConnect for Oracle