> -----Original Message----- > From: Donnie Bachan [mailto:[EMAIL PROTECTED] > Sent: Monday, June 23, 2003 9:33 PM > To: CF-Talk > Subject: OT: BLOBs and CF > > This is a slightly OT question and I know it has been debated before but > we > have a client that is intent on having us store all their files in a DB > and > I can not for the life of me come up with any good reason to do that. So I > would like to ask the community to help me out here: > > What are the Pros and Cons of storing files as BLOBs? And
The biggest one to me is the simple fact that all data is maintained in the same place. Back up the DB and you've got everything. Make the DB accessible to a client and they've got everything. Multiple client apps can access all information via the same methods. > What are the Pros and Cons of storing files in the file system with the > names stored in the DB? Well - it can be easier. It does also reduce the stress on the DB server. You can also do a hybrid approach: keep the data in the DB for integrity reasons but also cache the files on the web server file system for speed. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
