InfoQ

News

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

Posted by Jonathan Allen on Feb 05, 2008 06:56 AM

Community
.NET
Topics
Data Access ,
Performance & Scalability
Tags
ADO.NET

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.

No comments

Reply

Exclusive Content

Clojure

Rich Hickey discusses Clojure features and syntax, example code, functional programming, concurrency semantics, transactions, software transactional memory, agents, implementation and pain points.

Composite Oriented Programming with Qi4j

We introduce the concept of Composite Oriented Programming, and show how it avoids the issues with OOP and reignites the hope of being able to compose domain models with reusable pieces.

Dan Farino About MySpace’s Architecture

Dan Farino talks about the system architecture and the challenges faced when building a very large online community. Dan explains how a .NET product scales on hundreds of servers.

Principles and Practices of Lean-Agile Software Development

Alan Shalloway, CEO and founder of Net Objectives, presents the Lean software development principles and practices and how they can benefit to Agile practitioners.

The Maxine VM

Bernd Mathiske discusses Maxine VM, Java compatibility, swapping major VM components, research areas, Object handling, code examples, optimizing compiler, snippets, bytecode generation, JNI and JIT.

Joe Armstrong About Erlang

Joe Armstrong speaks on various aspects of the Erlang language, presenting its roots, how it compares with other languages and why it has become popular these days.

The Limits of Code Optimization: a new Singleton Pattern Implementation

The java double-check singleton pattern is not thread safe and can’t be fixed. In this article, Dr. Alexey Yakubovich provides an implementation of the Singleton pattern that he claims is thread-safe.

Pressure and Performance – The CTO's Dilemma

Diana and Jim talk about patterns observed in CTOs' activity. CTOs emerge as real people caring for other people in their organization, and are put under a lot of pressure and constraints.