IMHO, Having worked with and built systems that store the images in a database on many occasions, I would have to say that the best solution for the size of your project, IMO, would be to not do it that way. Store the images in a directory on the hard drive and the name of the image in your database. Further, I would not store the actual location of the image in the database as future iterations of the web structure may change and it is easier to indicate the location from the application. For instance, today all of the images may be stored in the 'userimages' directory. Yet next month you may get a request (demand) from the Server guy to separate all of these 90,000 images into separate sub directories.
Database backups and restores will happen MUCH faster and take up less space. You can do a backup of the images separately from a backup of the web-site. (Do a backup of the website on a 'on-changed' basis, while doing the image directory backup on a daily or weekly basis). Just a few of the reasons that come to the top of my mind to choose to NOT do the images in the database. Also, another suggestion. If you are going to port this to the public using a different database, your database options are better when you don't do the storing in the database. William ::-----Original Message----- ::From: Richard Dillman [mailto:[EMAIL PROTECTED] ::Sent: Saturday, March 22, 2008 11:40 AM ::To: CF-Talk ::Subject: Images in the database good or bad? :: ::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? :: ::I'd really like to get a lot of pro and con feedback on this. :: ::-- ::-- ::Richard Dillman ::[EMAIL PROTECTED] :: ::"There are painters who transform the sun to a yellow spot, but there are ::others who with the help of their art and their intelligence, transform a ::yellow spot into the sun." ::- Pablo Picasso :: :: :: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:301797 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
