BLOB insertion takes too long time

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hello,

I'm trying to insert some BLOB data into a SQL Server 2005 empty table, and
the size of BLOB varies from 100s of bytes to several MB. The thing is no
matter how small the size is, it'll almost take constantly 1 second to get
the insertion done which is much longer than expected. Anyone has any idea on
1) why constantly not linear to size 2) why that long time? I really
appreciate any help on this.

The table is simply:
CREATE TABLE AA
(
C1 CHAR(32) NOT NULL,
C2 CHAR(32) NOT NULL,
C3 INT NOT NULL,
CData varBinary(MAX) NOT NULL,
PRIMARY KEY (C1, C2)
)
Size in byte Time in ms
3209962 2219
1562524 1094
937994 1188
181319 1031
78878 1031
16713 969
11641 985
15231 953
469 1610


P.S., I'm writing my own C++ code and access the database through SQL Server
ODBC driver. The timing is between before and after sending SQL to ODBC
connection.

.

Relevant Pages

  • Unable to insert BLOB value into a MSSCE "image" field. Error: 8007000E - Not enough storage is
    ... When I'm trying to add BLOB data into a MS SQL Server Compact edition table I get following error ... First chance exception at $767442EB. ... messages sent by OutputDebugString API function. ...
    (borland.public.delphi.database.ado)
  • Re: Customized filter for content searching
    ... documents with SQL Server Full-Text Search in SQL Server 2000. ... As for your images you will need to store them separately ... Access and Modify SQL Server BLOB Data by Using the ... > I have some office documents which I am storing as image ...
    (microsoft.public.sqlserver.fulltext)
  • cant rebind placehodler - Blob, ODBC, SQL Server, DBI, Win32
    ... I have been banging my head against the wall for a while now trying to figure out why I can't upload a some blob data to a SQL Server database via DBI. ... SQLDescribeParam failed reverting to default type for this parameter: ... 773 0 obj ...
    (comp.lang.perl.misc)
  • Re: cant rebind placehodler - Blob, ODBC, SQL Server, DBI, Win32
    ... figure out why I can't upload a some blob data to a SQL Server database via DBI. ... This code is inside an object so $self->datareturns the blob data as a scalar and $self->idreturns the id of the record we are updating. ... The whole thing is in the context of a CGI application that is doing a file upload. ... $self->storagereturns a database handler to the SQL server and I generally haven't had any problems storing other types of data. ...
    (comp.lang.perl.misc)
  • Re: Full Text Search Setup
    ... have SQL Server 2000 SP3 on Win2003! ... by populating the column documentdoctype2 column with both ... Access and Modify SQL Server BLOB Data by Using the ... > (which is why we are storing the mime type.) ...
    (microsoft.public.sqlserver.fulltext)