I like storing binaries in a DB record. You get all the information in one place. You don't have to worry about keeping the DB and a file system synchronized. For example, if the DB thinks a file exists, but the file was manually deleted, you can have problems.
If you migrate to a different server/platform, you only have to worry about the DB, in many cases. As far as performance, it may be a bit slower, but it may not be. It depends on many different considerations. To me, the slow part is the long upload to the web server. From there, saving the file on the file system, or storing it in a DB, is pretty quick work. All in all, you will take up storage space "somewhere". Search the archives of this list for many other opinions and solutions. M!ke -----Original Message----- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Monday, November 21, 2005 9:54 AM To: CF-Talk Subject: Image Saving I'm working on an image saving application for a client and was wondering about methods of saving an original image to the server. Up to this point, I've just let someone save an original image to a directory location, then I run CFX_ImageCR routines on the file to manipulate it. My concern is space, that if I allow all my clients to upload originals, then the server will become full in a hurry. Mind you, these folks are using 6 megapixel + cameras, so each image could be 3mb or more. Having the client downsize the images prior to posting is not an option, as they are doing shots in the field and want to go to a walk-up PC and upload directly from a camera. I've read about saving images as BLOBs inside MS-SQL. Are there any advantages or pitfalls to doing it this way? Can the image be read out of the db and made useable by a server manipulation package (like ImageCR or others)? How does BLOB storage impact SQL performance? Thanks, Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224816 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
