Ja, Rick nails the typical scenario. Other considerations would be clusters (one FS isn't == to another FS), and keeping the DB in sync with the FS.
FS == File System And unless you break the file data into little pieces, you need special settings to store files in a DB (enable blob, clob, whatever in CF + things like max packet sizes on the DB side). I've done both and had great results with both. YRMV. Yet another option is storing the files on some type of external repository (NFS, or even SVN/etc.). Still need that meta data tho (descriptions, etc.). -- War is a quarrel between two thieves too cowardly to fight their own battle. Thomas Carlyle On Thu, Sep 24, 2009 at 7:27 PM, Rick Faircloth wrote: > > Well, typically, and I think, usually, the files would reside > on the server and you would use a database to maintain records > of the files...filenames, title, content description, etc. > > Then you would access the database to pull up the information > with links to the documents, themselves. > > > -----Original Message----- > From: fun and learning > Sent: Thursday, September 24, 2009 9:13 PM > To: cf-talk > Subject: Storing uploaded files > > > Hi, > > I am working on a functionality where the user has to upload files. Most of > the files or almost all files would be of pdf format. What is the best way > to store these files? On the server or on database? > > Thanks. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326617 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
