Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. PRB: Performance Issues with SQL Server OLE DB Provider When Working with BLOB Data Types

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

View products that this article applies to.

This article was previously published under Q281268

↑ Back to the top

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

↑ Back to the top

Resolution

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

↑ Back to the top

Status

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB281268, kbprovider, kbprb, kbdatabase

↑ Back to the top

Article Info
Article ID : 281268
Revision : 5
Created on : 12/5/2003
Published on : 12/5/2003
Exists online : False
Views : 298