> We have a client/server software package that stores all the files in > the > db that we are currenly rewriting in ColdFusion, but someone > on the team > has the idea that CF does not support file storage in the db. > I think > they were specifically referring to the storage of images, > but we will > need to store any type of file including but not limited to > PDF. If it > is not supported by coldfusion, then we will just store the > files out to > disk.
I'd have to imagine that the file system would be more efficient at storing files then a DB. I generally like to make a clear distinction between files and data. Store data about the files in the DB (including location on the disk) and store the actual files on disk. I don't know of any benchmarks, but i personally like to make that distinction. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
