Performance Issues

Developing performance-oriented .NET applications is not easy. The .NET standard includes only basic guidelines and interface definitions to help programmers develop .NET applications. The ADO.NET data providers do not automatically throw exceptions to say that your code is running too slowly.

Designing a .NET application is a complex process, in part because the code can be very data provider-specific. If you are working with several databases, you will find that the programming concepts vary between the different data providers. You will need much more database knowledge to design your application effectively.

Some guidelines for developing performance-oriented ADO.NET applications include:

• Retrieving only required data
• Selecting objects and methods that optimize performance
• Managing connections and updates

Refer to Designing .NET Applications for Performance Optimization in the DataDirect Connect Series for ADO.NET Reference for detailed information.