I tend to call this the "Solution looking for a problem" syndrome. Most people have NO USE in keeping the actual
images/documents in the database. A good candidate case would be when the documents are to be stored and not changed,
and database security is setup properly to leverage access to the resources.

Just remember, when you store a PDF or a JPG or a .AVI... whatever. If you are doing anything but archiving, think about
how tedious it will be to view/edit these documents when they are stored in a database.

Jason


Alan McDonald wrote:

>> I am about to add to an application the ability to store scanned
>> documents. There will be 10-12,000 documents per annum. The documents
>> will be held in a database containing only a single table which will
>> contain the document stored in a blob field and some other fields to
>> index the documents so that they can be retreived. Is this a sensible
>> approach? Can FB cope with this and are there any problems or pitfalls
>> of which I should be aware? Alternatively, I could store the documnets
>> on disk as jpg's or pdf's, with an entry in the database indicating the
>> file name. Is this a better approach?
>>
>
> IMO the latter approach is better, it makes backups a little more difficult
> though but it makes the db much lighter.
> You may get acceptable over-the-wire performance though, if you use the
> former accompanied by "on-the-fly" document compression (zipping) prior to
> storage.
> Alan
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.