Microsoft KB Archive/304365

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

Article ID: 304365

Article Last Modified on 9/17/2003

-

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.

Additional query words: BLOB SQLOLEDB Performance SP

Keywords: kbbug kbprovider kbdatabase kbpending KB304365

-

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

© Microsoft Corporation. All rights reserved.