PRB: Performance Issues with SQL Server OLE DB Provider When Working with BLOB Data Types (281268)


The information in this article applies to:

  • Microsoft OLE DB Provider for SQL Server 7.0
  • Microsoft OLE DB Provider for SQL Server 7.01
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
This article was previously published under Q281268

SYMPTOMS

The Microsoft OLE DB Provider for SQL Server (SQLOLEDB) is slower in inserting or updating BLOB data types such as text, ntext, or image when compared with the Microsoft OLE DB Provider for ODBC drivers (MSDASQL).

RESOLUTION

Use the Microsoft OLE DB Provider for ODBC drivers (MSDASQL) for BLOB data types when working with SQL Server.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a table in a SQL Server database with a column of type text, ntext, or image.
  2. Insert or update a row with approximately 5 megabytes (MB) or more of data into the BLOB column.
  3. Compare the performance of SQLOLEDB with MSDASQL.
Modification Type:MajorLast Reviewed:12/5/2003
Keywords:kbDatabase kbprb kbProvider KB281268
©2003 Microsoft Corporation. All rights reserved.