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:224805 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
