Microsoft KB Archive/901151

= 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 =

Article ID: 901151

Article Last Modified on 12/3/2007

-

APPLIES TO


 * Microsoft .NET Framework 1.1 Service Pack 1

-





SYMPTOMS
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.



CAUSE
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:

889100 How to obtain the latest service pack for Windows Server 2003

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.   Date         Time   Version        Size       File name -  17-Jun-2005  05:29  1.1.4322.2333  1,298,432  System_data.dll



WORKAROUND
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.



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



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

824684 Description of the standard terminology that is used to describe Microsoft software updates

Keywords: kbwinserv2003sp2fix kbperformance kbfix kbqfe kbbug kbhotfixserver KB901151

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.