I've never stored the images in a database like that... Honestly, I never save the original.
They upload the image, I process it with ImageCR3, overwrite the original with the newly processed version and create any thumbnails from there. You might consider some zip/unzip routines for each client's directory contents if you must keep the original huge images. Everytime they upload a new image, run your imagecr processes and then zip the content of that directory. Until the user wanted one of their originals back, there would be no need to extract anything from the zips. ....that's just an untested idea though. It may or may not be better to store them in the database like you mentioned. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Monday, November 21, 2005 10: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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224815 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
