Using BLOBs in SQL

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Can anyone tell me what the pros/cons are of using blobs in sql?

We are looking at scanning certain paperwork and storing it with the
appropriate records in our database. The two options are to store the images
as blobs or to store them as file system objects with a referral pointer in
the db.

I have heard a number of different people say that storing blobs is
inherently evil but they haven't explained why that is.

Any help will be appreciated.

.

Relevant Pages

  • Re: Ideas on storing and retriving files in a Windows Application
    ... files etc. 2) Because it is stored in a relational database, ... blobs takes some minor modifications other than just using SELECT blah FROM ... horror stories of people who started storing BLOB data in a db only to have ... > will open the appropiatte application to display the file and 2. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Blob in Access
    ... My first use of BLOBs in Access was with aserver back end, ... the server was capable of storing all the pictures, ... store in the shared back-end as BLOBs, but with "many" documents, increasing ...
    (comp.databases.ms-access)
  • Re: Using BLOBs in SQL
    ... I've been looking at methods of storing PDF files ... The two options are to store the ... > as blobs or to store them as file system objects with a referral pointer ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Using BLOBs in SQL
    ... SQL Server MVP ... >> We are looking at scanning certain paperwork and storing it with the ... The two options are to store the ... >> as blobs or to store them as file system objects with a referral pointer ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Timeout when inserting BLOB records
    ... how do you find storing this much blob data - is it better than storing ... > adding tif images as BLOBs to rows in a table in SQL2000. ... > The database holds approx 142,000 image records and the database size is ...
    (microsoft.public.sqlserver.programming)