> 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? Honestly I'm looking at a long-term answer > here for a government contract. The items can be re-uploaded > via an admin screen. and there will probably be 10,000 new > items per year with a 3-year retention schedule. > > Granted, I'm designing this with SQL server but I will > probably want to port this to MySQL for the private sector > when it's all done. Please bare that in mind. > > In a hosted solution where I might wind up with 20 of these > apps on the same sandbox which do you see as the better option?
For a government solution, you may need to conform to specific auditing and/or security requirements that would limit your choices (most likely, requiring storage separate from the application server). You might want to check into that. MS SQL Server will work fine for image storage. I'm not sure about MySQL. Is your hosted environment shared or dedicated? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:301825 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
