Performance problem when loading Model

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Perez
Posts: 2
Joined: Wed 02 Sep 2009 18:34

Performance problem when loading Model

Post by Perez » Wed 02 Sep 2009 18:37

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 !

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

Post by AndreyR » Thu 03 Sep 2009 07:18

Could you please specify the versions of dotConnect for Oracle, Oracle server, and Oracle client (if you have one)?

Perez
Posts: 2
Joined: Wed 02 Sep 2009 18:34

Post by Perez » Thu 03 Sep 2009 13:40

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.

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 07 Sep 2009 08:50

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.

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

Post by AndreyR » Wed 16 Sep 2009 09:58

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

Post Reply