In my opinion, a database is used to organize "related" data. In this case, a binary file would be related to its metadata that you would normally store in a database.
m!ke -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Saturday, March 22, 2008 6:23 PM To: CF-Talk Subject: Re: Images in the database good or bad? >> Is it better to do a file upload, or better to insert to the database? The basic idea of a database is to organize data in such a way it can be searched and sorted. In principle, there is nothing to be searched or sorted in an image, so put it in the database will just add an overhead on the database engine for nothing. It is considered best practice to use the file storage facilities of the system hosting the application and only store in the database information about the image, like file name, size, type etc. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:301808 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
