Michael, One of the things I have always been against is storing images into a database.
But you have raised a good point for smaller sites, that are not part of a farm or cluster. And the thing that I was going to say in this thread that no one else seems to have touched on either is how heavy the site is going to be. The reason that is important is, if it is a heavy site and pulls the images out of the database will put a huge load on congestion if it is a heavy used section. So the question is not the best method, it is going to be the best method for your plan. (to the original poster) On Sun, Mar 23, 2008 at 1:17 PM, Dawson, Michael <[EMAIL PROTECTED]> wrote: > >A database with 90,000 images in it will take longer to backup than a > database that doesn't have that binary data stored in it. > > True. But, you didn't take into account the amount of time it will take > to backup the file system. > > As Paul mentioned, you have to back up the images, somewhere, sometime. > > I would prefer to keep my system in-sync by keeping the binaries in the > database. Let's say you have to restore from a crash... > > My database backup runs at 1:30am. However, the sysadmin can't backup > the file server until 7:30am. If I have to restore both systems, I > have six hours of potential loss and a good chance that my system will > be out-of-sync after the restore. > > m!ke > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:301818 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
