BLOB ???

  • Thread starter Thread starter KS
  • Start date Start date
K

KS

1) Does it slow down the performance on the network ?
2) Does it make your DB's grown wild ?
3) What kind of datatype should I use in the SQL-db doe the BLOB-field ?
4) How can I know what kind of "document" is crushed in the BLOB-field
(Word, Excel, Image, Mail aso ) ?

Best regards
KSor, Denmark
 
KSor,

Are you using a SQL Server 2008 that has special features for Blob fields
(they are written as file to a special folder but referenced by the SQL
server)

To have a Blob field direct in your database (while the blob field is more
than a thumbnail) makes it terrible slow.

Have a look at that SQL Server 2008, that explains probably as well that
doing this with other servers makes it slow.

Cor
 
KSor,

Are you using a SQL Server 2008 that has special features for Blob fields
(they are written as file to a special folder but referenced by the SQL
server)

To have a Blob field direct in your database (while the blob field is more
than a thumbnail) makes it terrible slow.

Have a look at that SQL Server 2008, that explains probably as well that
doing this with other servers makes it slow.

Cor
 
Pete,

A Blob is simple another name for a Byte Array, it can contain everything
and is very good usable in C# using the memory stream.

Cor

Peter Duniho said:
[BLOB stuff]
Click to expand...

There is no C# feature that is relevant to the BLOB data type. It looks
like you may have accidently posted to the wrong newsgroup.

I recommend finding a SQL-specific newsgroup, and posting your question
there.
Click to expand...
 
Pete,

A Blob is simple another name for a Byte Array, it can contain everything
and is very good usable in C# using the memory stream.

Cor

Peter Duniho said:
[BLOB stuff]
Click to expand...

There is no C# feature that is relevant to the BLOB data type. It looks
like you may have accidently posted to the wrong newsgroup.

I recommend finding a SQL-specific newsgroup, and posting your question
there.
Click to expand...
 
Pete,

It is not important, but in SQL Server the columntype Blob does as well not
exist.

There it is just another name for Image.

Cor
 
Pete,

It is not important, but in SQL Server the columntype Blob does as well not
exist.

There it is just another name for Image.

Cor
 
KS said:
1) Does it slow down the performance on the network ?
Click to expand...

Most likely not, if you compare to the case where data in blob is sliced
and each slice is stored into its own row, since transferring the blob
the database is only transferring the blob, where are transferring the
rows, for each row it has to transfer extra information (row number,
start-of-the-transfer, end-of-the-transfer markers etc.)
2) Does it make your DB's grown wild ?
Click to expand...

Most likely not, since blobs are built from start to handle large data,
so changing blob most likely does not leave so much garbage.
3) What kind of datatype should I use in the SQL-db doe the BLOB-field ?
Click to expand...

Since a blob is a single datum to the the database, it should be a
single datum to you too, like still image, video etc.
4) How can I know what kind of "document" is crushed in the BLOB-field
(Word, Excel, Image, Mail aso ) ?
Click to expand...

You don't (I guess). If there are several possibilities, most likely the
table has two fields, the blob and something telling what the blob contains.

And yes, as told, this has nothing to do with C#.
 
KS said:
1) Does it slow down the performance on the network ?
Click to expand...

Most likely not, if you compare to the case where data in blob is sliced
and each slice is stored into its own row, since transferring the blob
the database is only transferring the blob, where are transferring the
rows, for each row it has to transfer extra information (row number,
start-of-the-transfer, end-of-the-transfer markers etc.)
2) Does it make your DB's grown wild ?
Click to expand...

Most likely not, since blobs are built from start to handle large data,
so changing blob most likely does not leave so much garbage.
3) What kind of datatype should I use in the SQL-db doe the BLOB-field ?
Click to expand...

Since a blob is a single datum to the the database, it should be a
single datum to you too, like still image, video etc.
4) How can I know what kind of "document" is crushed in the BLOB-field
(Word, Excel, Image, Mail aso ) ?
Click to expand...

You don't (I guess). If there are several possibilities, most likely the
table has two fields, the blob and something telling what the blob contains.

And yes, as told, this has nothing to do with C#.
 
Back
Top