It simplifies security for us (don't have to deal with filesystem
security). It is easier for our dmz located java servers to access the
files without having to resort to nfs or anything like that as well. I
have good control over auditing views/changes/deletes/etc.

I guess it depends on what you are using it for.

-steve

Jason Dodson wrote:

> 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.
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>
>
>
>
>
>
>