InfoQ Homepage News Free ADO.NET Performance Improvements in .NET 2.0 SP 1

Free ADO.NET Performance Improvements in .NET 2.0 SP 1


Service Pack 1 for .NET 2.0 includes significant performance improvements for ADO.NET. We say they improvements are free because the changes do not require recompiling the code, any user installing the service pack should see at least some gains.

According to the ADO.NET Team Blog, SqlReader can see a 27% improvement and DataSet inserts get a whopping 41% improvement. SP 1 is included the .NET 3.5 Redistributables and SDK. Since they are not dependent on Visual Studio 2008, VS 2005 developers can also see these benefits.

Bruno Guardia, a Test Lead at Microsoft, said that at least some of the performance improvements should be seen even in proprietary data providers exposed via ADO.NET. While he did not go into detail, but he did mention some of these improvements come from bug fixes and from changes in the threadpool algorithm that make context changes more efficient.

We need your feedback

How might we improve InfoQ for you

Thank you for being an InfoQ reader.

Each year, we seek feedback from our readers to help us improve InfoQ. Would you mind spending 2 minutes to share your feedback in our short survey? Your feedback will directly help us continually evolve how we support you.

Take the Survey

Rate this Article


Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p


Is your profile up-to-date? Please take a moment to review and update.

Note: If updating/changing your email, a validation request will be sent

Company name:
Company role:
Company size:
You will be sent an email to validate the new email address. This pop-up will close itself in a few moments.