>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:301817 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
