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


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 OLE DB Provider for SQL Server 2000 2000.80.194
  • Microsoft Data Access Components 2.8
This article was previously published under Q304365

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.

STATUS

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

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.
Modification Type:MajorLast Reviewed:9/17/2003
Keywords:kbbug kbDatabase kbpending kbProvider KB304365
©2003 Microsoft Corporation. All rights reserved.