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 !
Performance problem when loading Model
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.
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
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