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. BUG: Slow Performance with SQLOLEDB Inserting BLOB Data into SQL Server Using Stored Procedure

BUG: Slow Performance with SQLOLEDB Inserting BLOB Data into SQL Server Using Stored Procedure

View products that this article applies to.

This article was previously published under Q304365

↑ Back to the top

Symptoms

The Microsoft OLE DB provider for SQL Server (SQLOLEDB) is almost ten times slower than the Microsoft OLE DB provider for ODBC Drivers (MSDASQL) when inserting binary large object (BLOB) data into a SQL Server database using a stored procedure.

↑ Back to the top

Status

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

↑ Back to the top

More information

The above behavior with the SQLOLEDB provider may not be exhibited when inserting small amounts of data. The SQLOLEDB provider becomes less efficient as the size of inserted data grows.

↑ Back to the top

Keywords: kbbug, kbdatabase, kbpending, kbprovider, KB304365

↑ Back to the top

Article Info
Article ID : 304365
Revision : 3
Created on : 9/17/2003
Published on : 9/17/2003
Exists online : False
Views : 273