Tutorial: Designing Performance-Optimized .NET Applications

View PDF

This document presents some general guidelines to help you improve the performance of your .NET applications.

In addition, it contains C# code examples that illustrate best practices for optimizing performance, including:

• Determining connection requirements leads to better data source design and more effective use of connection pooling.
• Using managed code takes advantage of features in the .NET Framework such as security, automatic memory management, and garbage collection.
• Selecting the right .NET objects and methods can optimize resources. For example, choosing whether to use a DataReader or DataSet depends on your production environment. Similarly, using a CommandBuilder object can have drawbacks.
• Using the correct transaction model, managing commits, and retrieving and updating data efficiently can reduce network input/output.

NOTE: Many code examples in this document use syntax introduced in the Microsoft .NET Framework 2.0, such as the generic DbProviderFactories. If you are using an earlier version of the .NET Framework or the DataDirect Connect® for .NET 2.2 data providers, refer to Designing Performance-Optimized .NET Applications.

• Introduction
• Designing .NET Applications
• Selecting .NET Objects and Methods
• Retrieving Data
• Updating Data
• Conclusion