FIX: An application may experience a performance decrease when you try to add a column or when you try to access the data by using a name or an index in the .NET Framework 1.1 SP1

On a computer that is running the Microsoft .NET Framework 1.1 Service Pack 1 (SP1), an application may experience a performance decrease when a table contains lots of columns. This problem occurs when either of the following conditions is true:

• You try to use the DataColumnCollection.Add function to add a column to a table.
  
  Note Typically, this problem occurs when the table contains approximately 40,000 columns.
• You try to access the data by using a name or an index in a specific row and column.
  
  Note Typically, this problem occurs when the table contains more than 5,000 columns.

This problem occurs because ADO.NET that is included with the .NET Framework 1.1 SP1 performs error and validation checks and the event implementation on each existing column. This behavior occurs when you use the DataColumnCollection.Add function to add a column to a table. If the table already contains lots of columns, many error and validation checks and event implementations occur before the new column is added. This behavior causes the performance decrease to occur.

Service pack information

To resolve this problem, obtain the latest service pack for Windows Server 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

Software update information

Prerequisites

You must have the Microsoft .NET Framework 1.1 Service Pack 1 installed before you apply this software update.

Restart requirement

You do not have to restart the computer after you apply this software update.

Software update replacement information

This software update does not replace any other software updates.

File information

The English version of this software update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.

To work around this problem, use the DataColumn object to access the data. For example, use the DataColumn object instead of a name or an index to access the data in a column.

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Windows Server 2003 Service Pack 2.

For more information, click the following article number to view the article in the Microsoft Knowledge Base: