yeah I tell people exactly that... however when you start to have 5000 or more images and are growing them at hundreds per day it seems like the database is a good place as opposed to the file system that can't handle the mass of files and would requires some pretty nifty subdirectory flexible management and growth building algorithm... Additionally, putting meta data with the file and within the file and in the database makes it all queryable and nice so we can move/backup one large chunk instead of 5000 files plus database :)
In my project it is photos that are the issue... :) we have a big print image (1-2 megabytes), a thumb nail, and a screensaver/normal people version... so 3 fetches :) -paris -----Original Message----- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 16:44 To: CF-Talk Subject: RE: MySQL and binary data I've considered doing that (with SQL Server). Before you beign, I've been told over and over again is that it's a bad practice to store images in databases. Instead, have a column that points to the path of the file. In you do that, you'll have to cffile (write) the data the pull from the database into a jpeg file. Then use CFcontent to display (and delete). This method is pretty slow when you do several images at once. Just letting you know just in case. As for mySQL, I dunno. :/ EC -----Original Message----- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 4:28 PM To: CF-Talk Subject: MySQL and binary data ok was wondering if anyone using MySQL with ColdFusion, if they were utilizing the BLOB types to store data in the database? Specifically, I am wondering how easy it is or isn't to write things like JPEGs in there and get them back out and into the Cold Fusion pages... anyone have any sample code, recommendations, pointers, etc? -paris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
