Performance Comparison

Thread is closed for posting
4 posts, 0 answers
  1. Naresh
    Naresh avatar
    31 posts
    Member since:
    Mar 2009

    Posted 08 Apr 2009 Link to this post

    Hello,

    We are considering using OpenAccess for a new mission critical web application. I'm searching for a performance comparison between OpenAccess, other ORM's and native ADO.NET. I've had no luck finding any hard numbers.

    Do you have any data that you can point me to?

    Thank you,
    Brian
  2. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 10 Apr 2009 Link to this post

    Hi Brian,
    We do not provide official documents on the topic so far. We are considering at the moment whether to provide such on a company level. What I'm authorized to share so far is that we have similar performance to EntityFramework in most cases and are faster that some of the other vendors. Also you have to know that Plain ADO.NET (as expected) has the best performance, it is just that you have to maintain a lot of code that is usually not very portable and maintainable.  My suggestion is:

    If you are very dependable on performance (and the maintenance cost is of no importance), maybe you should go with ADO.NET and forget about O/R mappers. Actually we do provide optimizations like L2 cache and fetch optimizations, but nevertheless there will be a small performance overhead always compared to ADO.NET (I assume that we compare an optimal ado.net implementation).

    In all other cases I suggest that you take the time and make a sample/spike with OpenAccess to see some specifics whether it works for you. We can guide you through the process as we provide support even for the trial downloads.

    Hope that helps with your decision. Do not hesitate to contact me further.

    Best wishes,
    Dimitar Kapitanov
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  3. Naresh
    Naresh avatar
    31 posts
    Member since:
    Mar 2009

    Posted 10 Apr 2009 Link to this post

    Dimitar,

    Thank you very much for your honest response. We are a new Telerik customer and it's great to know that we're dealing with a company that is not afraid to say their product may not be the best solution.

    We are planning on doing a proof of concept to determine what is best for our situation.

    Thank you,
    Brian
  4. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 10 Apr 2009 Link to this post

    Hello Brian,
    Embracing the full  spectrum of functionality that OpenAccess provides will require a learning curve on your side that may require additional assistance by us, especially for advanced features like caching, fetch optimizations, etc. Please do not hesitate to contact our support, and we will evaluate your requests as soon as possible.

    Best wishes,
    Dimitar Kapitanov
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
Back to Top