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
Accessing Oracle much slower than SQL Server
Here are some links about the Entity Framework performance:
http://blogs.msdn.com/b/adonet/archive/ ... art-1.aspx
http://blogs.msdn.com/b/adonet/archive/ ... art-2.aspx
http://msdn.microsoft.com/en-us/library/bb896240.aspx
Try View Pre-generation, this should help.
http://blogs.msdn.com/b/adonet/archive/ ... art-1.aspx
http://blogs.msdn.com/b/adonet/archive/ ... art-2.aspx
http://msdn.microsoft.com/en-us/library/bb896240.aspx
Try View Pre-generation, this should help.