Yes, I agree also with metadata in the db. Good point.

Randy


On Mar 16, 2005, at 3:28 PM, [EMAIL PROTECTED] wrote:

I personally prefer to put the file on the FS and place the link (file
location) into the DB. As for clustering problems, have you looked into
cluster file systems like AFS?


On Wed, 16 Mar 2005, Andrew Huntwork wrote:

I'm writing this web app that allows users to upload documents, such as
word docs, images, etc, and then to download those documents again on
request. the documents are not searched, interpretted, processed,
version controlled, or anything else. just upload and download. i
wonder if there's a general rule on whether one should stick such things
into a db or onto the file system.


i currently favor sticking them in the db. putting them on the fs seems
to interfere with clustering (different files would be on different
filesystems). it's also another thing to back up and generally
maintain. on the other hand putting them in the db puts extra load on
the db and the network. there are a bunch of other issues too.


Any ideas?  Thanks for any help.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to