Data Access for high performance application

added by ebizdom
6/12/2012 3:18:23 PM

0 Kicks, 138 Views

Recently i was working on a project where application performance was a top priority. I started looking into ORM frameworks and found that ORMs are great for most applications, but when performance is a factor it�s best to write your own data access. So that's when I decided to write my own data access. This article will explain some of the design that i have used in my project. I have used SqlDataReader�s strongly typed Get methods to do a null check and then write the values. Here is my base class in VB.NET.


3 comments

dpeterson
6/13/2012 8:46:17 AM
Did you perform any sort of benchmarks comparing the performance of the code you've written to the performance of an ORM? How about when the ORM uses a stored procedure as your code does? Which ORMs were you evaluating when you decided to write your own DAL?

ebizdom
6/13/2012 9:30:54 AM
I did some research and found an interesting article that might help you. Please take a look here. http://www.luisrocha.net/2011/12/data-access-performance-comparison-in.html

dpeterson
6/13/2012 9:34:48 AM
Thanks for the info.