Page 1 of 1
Performance problem when loading Model
Posted: Wed 02 Sep 2009 18:37
by Perez
Hello all,
I got a huge performance problem when I load only one table from my Oracle Database. Entity Framework takes 15 minutes to load only one entity from the Database when I use DotConnect for Oracle.
Thanx a lot for any help !
Posted: Thu 03 Sep 2009 07:18
by AndreyR
Could you please specify the versions of dotConnect for Oracle, Oracle server, and Oracle client (if you have one)?
Posted: Thu 03 Sep 2009 13:40
by Perez
I'm using dotConnect for Oracle 5.25 Professional Trial
on a 9.2.0.7.0 Oracle server. I have Oracle Client 10G installed on my machine.
Thank you verry much.
Posted: Mon 07 Sep 2009 08:50
by Shalex
Could you please send us your model and the DDL/DML script to create your table and to fill it with the data set you have? Please contact us via our contact form:
http://www.devart.com/company/contact.html . We will investigate the issue.
Posted: Wed 16 Sep 2009 09:58
by AndreyR
Any ORM has some performance problems in different cases, Entity Framework is not an exception.
There is a number of ways to overcome common problems.
Please refer to the article about EF performance here:
http://msdn.microsoft.com/en-us/library/bb896240.aspx
If the model is considerably large, time-consuming actions are made before the database is queried for the first time.
This problem can be partially solved using view pregeneration, it is described here:
http://msdn.microsoft.com/en-us/library/bb896240.aspx