Performance Issue in Entity Framework

Question

0.00/5 (No votes)

See more:

Hi ,
I am facing critical problem using Entity Framework. When I fetch one record from database , the query takes more than 5 min. We have more than 150 tables and I have created 10 EDMX for related tables. I would like to know to to improve performance. Please help me.
Environment :-
Database :- Oracle 10 G
OS :- windows 2008 server
Visual Studio 2008
Regards,
Rajesh

Posted 28-Oct-10 21:48pm

Rajesh_K_Sharma

Add a Solution

Comments

ARopo 29-Oct-10 4:05am

How long does the query take if you do it in SQL on the database? If it takes a long time here the problem is with the database.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rajesh Anuhya · Answer 1 · 2010-10-29T00:34:00

Solution 1

There may be a so many reasons for this.., i have a big database in oracle10g(almost 1TB). i able to get the data (even complex query) less than one minute..,

check your database for Proper normalization, Indexes etc..,

Use any performance tuner to analyze the DB & Quries

Posted 29-Oct-10 0:34am

Rajesh Anuhya

Performance Issue in Entity Framework

1 solution

Solution 1

Add your solution here

Preview 0

Performance Issue in Entity Framework

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us