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
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.