Accessing Oracle much slower than SQL Server
Posted: 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
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