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]
