This question is locked. New answers and comments are not allowed.
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
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
3 Answers, 1 is accepted
0
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.
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.
0
Naresh
Top achievements
Rank 1
Rank 1
answered on 10 Apr 2009, 02:21 PM
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
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
0
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.
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.