Performance

Thread is closed for posting
2 posts, 0 answers
  1. Sven
    Sven avatar
    6 posts
    Member since:
    Jun 2009

    Posted 14 Jul 2009 Link to this post

    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();

     

    }

     

    }

     

  2. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 15 Jul 2009 Link to this post

    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.
Back to Top