Richard Dillman wrote: > I'm in the process of designing a site that will allow people to upload > (JPG,PDF,DOC,XLS) files. I'm looking at about 1-4 mb each item. Is it better > to do a file upload, or better to insert to the database?
I find keeping the images in the database is more manageable with everthing you need in one place. However keeping them on the filesystem performs better. Not only because you reduce the number of layers involved (webserver, CF, DB and filesystem versus webserver and filesystem), but also because CF has a tendency to become a bottleneck and memory hog serving many files from a database. If you go that way, make sure you write the actual code that serves the images in plain Java instead of CF so you can stream the file. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
