This is a migrated thread and some comments may be shown as answers.
Performance
1 Answer 43 Views
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Sven
Top achievements
Rank 1
Sven asked on 14 Jul 2009, 03:32 PM
Gents,
can you please have a look at this "Performance" Test between latest Telerik & EF: The EF appears to be 4 times fast with 400000 records in a local SqlServer-Environment. I know this way of "performance-testing" is not the best, but we have lots of pro vs. cons ORM/Datareader/Writer:

 

public List<Car> CarsTelerikData { get; set; }

 

 

public List<Cars> CarsEFData { get; set; }

 

 


 

for (int i = 0; i < 6; i++) // 6 times 400000 records

 

{

Stopwatch sw;

sw =

new Stopwatch();

 

sw.Start();

CarsEFData = GetCarEFData();

sw.Stop();

ef.Add(sw.Elapsed.TotalSeconds);

 

Stopwatch sw1 =

new Stopwatch();

 

sw1.Start();

CarsTelerikData = GetCarTelerikData();

sw1.Stop();

telerik.Add(sw1.Elapsed.TotalSeconds);

}

}

 

private List<Cars> GetCarEFData()

 

{

 

 

using (SofiaCarRentalEntities context = new SofiaCarRentalEntities())

 

{

 

return context.Cars.Where(car => car.Model == "VW Touran").ToList();

 

}

 

}

 

private List<Car> GetCarTelerikData()

 

{

 

using (IObjectScope scope = SofiaCarRentalDBProvider.GetNewObjectScope())

 

{

 

return scope.Extent<Car>().Where(car => car.Model == "VW Touran").ToList();

 

}

 

}

 

1 Answer, 1 is accepted

Sort by
0
Dimitar Kapitanov
Telerik team
answered on 15 Jul 2009, 06:14 AM
Hi Sven,
We are very interested in your findings. We did some performance metrics on our own and the results are a bit different. If it is possible, please provide us with a sample application that includes the code you sent us, the two models (OA and EF) and a sample database to use for the testing. Please inform us whether this is possible. We will do our best to profile and detect what went wrong, because as I said earlier we never saw such performance results until now. Thanks in advance.

Sincerely yours,
Dimitar Kapitanov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Tags
General Discussions
Asked by
Sven
Top achievements
Rank 1
Answers by
Dimitar Kapitanov
Telerik team
Share this question
or