RE: FN-FORUM: Storing image collections in SQL Sever

date posted 1st April 2003 17:18

Nah,

I still don't think it's a good idea to store the images in the database;
I'm guessing from the size and the security / access concerns that these are
document scans rather than pictures; if that's the case, OCR the documents
and store the text in a full-text indexed field, so you can pull back and
display the text, with a link to the image if the user wants to see it; this
way they get the content 24/7 AND it's secure, but still have the important
ability to view the original document if necessary.

A.


-----Original Message-----
From: Darran Shepherd [EMAIL REMOVED]
Sent: 01 April 2003 15:37
To: FN-FORUM / [EMAIL REMOVED]
Subject: RE: FN-FORUM: Storing image collections in SQL Sever


> You also need to establish that if=20
> you're storing all that data in the database rather than as=20 links
> then you may need to switch to SQL Server Enterprise.

You've got me intrigued now Andy. Why do you say there's a need to = swith
to SQL Server Enterprise? Is it just because of the sheer volume of data
involved?

Darran.



==========