Wednesday, February 27, 2013

Performance analyze ADO.NET and Entity Framework


Hi, Friends
In this blog we discussed about Performance analyze of ADO.NET and Entity Framework.
Which one gives better performance? ADO.NET or Entity Framework.
These are the two method I want to analyze.    

ADO.NET Test Method 



Write a simple method to test ADO.NET.It contain a simple select query  it will return more than 1000 rows and  we put the "Stopwatch" class it helps to  calculate the execution time

Entity Framework Test Method


Write a simple method to test Entity Framework.It contain a simple ORM it will return more than 1000 rows and  we put the "Stopwatch" class it helps to  calculate the execution time

Result in first time execution 


When i ran this above method in more than 100 times.The average execution  time was show in the above image. ADO.NET was took only 2 milliseconds weather  Entity Framework took more than 4 milliseconds . 

Result in second time execution 


When i ran this method again and again in single run. The average execution  time was show in the above image. The  average execution  time between ADO.NET and EF is not much more 

Conclusion

I think EF gives very worst performance in first time execution . To improve the EF performance read this article 

Thanks 
Niventh@ abi

No comments:

Post a Comment