For what it's worth, we had a site here one time in which the developer that wrote the site never really cleaned up after himself and left images (hundreds of MBs!) all over the place, even when items associated with those images were deleted from the database. One of the solutions we developed after that problem was to put all of the images in the database -- not the image data itself, but the filename. Large images, smaller images, thumbnails, etc. That way you'll always know what images are supposed to be there, and if you're not sure you're just one query away from finding out. Also makes writing a cleanup script much eaiser. Just a thought.
Ryan Heldt > -----Original Message----- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 07, 2007 7:54 AM > To: CF-Talk > Subject: Re: Image Management > > >>My gut reaction is that this would add overhead, a > dependency on the database, network traffic, etc. What are > your thoughts? > > This sbject has been brought many times. > You're right > The purpose of a database is to store information in such a > way that it can be sorted and searched more easily. An image > file is just a bunch of binary data, there is nothing that > can be searched or sorted in an image, except may be in the > name of the file. > The best tool to store such information is the file > management system in the operating system. > You can store anything in the database, like the file name, > owner's name, image type, sizes, subject, key words, but the > right place of the image itself is in some directory. > Storing the image in the database will just add overhead > without any of the advantages brought by a database. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292834 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
