Microsoft KB Archive/281268

= PRB: Performance Issues with SQL Server OLE DB Provider When Working with BLOB Data Types =

Article ID: 281268

Article Last Modified on 12/5/2003

-

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.



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.

Keywords: kbprovider kbdatabase kbprb KB281268

-

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

© Microsoft Corporation. All rights reserved.