Storing Images

[Puneet Puneet_dh]

Hi Bill,
I have to store Images In my database,Since number of files to store could
be ranging from one to lacks.
How can ADO help me in faster retreival of image from SQL Server?
I have files in Tiff format.
Regards

Puneet Dhawan

[Bill Vaughn]

I'm not a fan of storing BLOBs (binary large objects) such as pictures in
the database. The file system is far better suited for this and can retrieve
selected files far, far faster and easier. There are examples of BLOB handling
AppendChunk, GetChunk and when these are needed and how to best handle them
in my book.

bv

"Puneet" Puneet_dh wrote:
>
>Hi Bill,
>I have to store Images In my database,Since number of files to store could
>be ranging from one to lacks.
>How can ADO help me in faster retreival of image from SQL Server?
>I have files in Tiff format.
>Regards
>
>Puneet Dhawan

[Eric Ford]

Bill,

I overheard a comment from another developer on Sql Server that storing
BLOBs and/or Text fields interferes with or disables transaction logging
until the next full backup is performed. Can you confirm or dispel that
assertion?

"Bill Vaughn" <billva@microsoft.com> wrote:
>
>I'm not a fan of storing BLOBs (binary large objects) such as pictures in
>the database. The file system is far better suited for this and can retrieve
>selected files far, far faster and easier. There are examples of BLOB handling
>AppendChunk, GetChunk and when these are needed and how to best handle them
>in my book.
>
>bv
>
>"Puneet" Puneet_dh wrote:
>>
>>Hi Bill,
>>I have to store Images In my database,Since number of files to store could
>>be ranging from one to lacks.
>>How can ADO help me in faster retreival of image from SQL Server?
>>I have files in Tiff format.
>>Regards
>>
>>Puneet Dhawan
>

[Bill Vaughn]

SS changes all the time. I was under the impression that BLOB operations were
logged so they would consume a great deal of space (potentially). This might
have changed (I doubt it)--but I'm not sure. The best way to avoid this problem
is to keep BLOBs out of the database. Save pointers to the BLOBs stored as
files elsewhere (on CD if they are RO).

bv
"Eric Ford" <Eric_S_Ford@hotmail.com> wrote:
>
>Bill,
>
> I overheard a comment from another developer on Sql Server that storing
>BLOBs and/or Text fields interferes with or disables transaction logging
>until the next full backup is performed. Can you confirm or dispel that
>assertion?
>
>"Bill Vaughn" <billva@microsoft.com> wrote:
>>
>>I'm not a fan of storing BLOBs (binary large objects) such as pictures
in
>>the database. The file system is far better suited for this and can retrieve
>>selected files far, far faster and easier. There are examples of BLOB handling
>>AppendChunk, GetChunk and when these are needed and how to best handle
them
>>in my book.
>>
>>bv
>>
>>"Puneet" Puneet_dh wrote:
>>>
>>>Hi Bill,
>>>I have to store Images In my database,Since number of files to store could
>>>be ranging from one to lacks.
>>>How can ADO help me in faster retreival of image from SQL Server?
>>>I have files in Tiff format.
>>>Regards
>>>
>>>Puneet Dhawan
>>
>