Visit Map

Sunday, April 17, 2005

Checklist:ADO.NET Performance

While browsing the Net i came across one book
Improving .NET Application Performance and Scalability called ScaleNet.pdf
You can download the same from www.microsoft.com/practices
The book is very goood. I suggest you to read that book

In that they given a checklist
Here is checklist for ADO.NET Performance

Design your data access layer based on how the data is used.
Cache data to avoid unnecessary work.
Connect by using service accounts.
Acquire late, release early.
Close disposable resources.
Reduce round trips.
Return only the data you need.
Use Windows authentication.
Choose the appropriate transaction type.
Use stored procedures.
Prioritize performance, maintainability, and productivity when you choose how to pass data
across layers.
Consider how to handle exceptions.
Use appropriate normalization
If you follow the above checklist you can increase the performence of a .NET Application

No comments: