Storing Files IN a database

From: Sean <dolans_at_my-deja.com>
Date: Wed, 01 Nov 2000 23:30:41 GMT
Message-ID: <8tq931$r30$1@nnrp1.deja.com>

Oracle 8.1.6 on Wint 4.0 - Java Options not installed at the moment.

QUESTION: Opinions requested on storing files in the database versus as files on the operating system.

Task at Hand: A web server that feeds back requested files. The idea at first was to store the files on the operating system, but the directory structure became extremely complex to sync it with what was in the database (on top of the rights architecture we have designed in the dbase). One possible solution we are investigating is to store the file as a BLOB in the system and ???? (feed it) back to the client.

I am curious on opinions of this approach. I have heard in the PAST that it was always best to store a link to the file, but I am curious about storage, performance, and ways to stream the file to the user.

Much appreciated,
Sean Dolan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 01 2000 - 17:30:41 CST