BT

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

| by Jonathan Allen Follow 641 Followers on Feb 05, 2008. Estimated reading time: less than one minute |

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.

Rate this Article

Adoption Stage
Style

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.

Tell us what you think

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

Email me replies to any of my messages in this thread
Community comments

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

Email me replies to any of my messages in this thread

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

Email me replies to any of my messages in this thread

Discuss
BT