Yes, never with CF, but I've done it before, and I've employed caching techniques both on the server and on the load balancer to assist, but I'd do that even it they weren't coming from the DB.
You don't put static page images in the DB, that doesn't make sense, but if you are wanting to replicate the data to multiple locations, it seems silly to have to replicate file content when SQL Server has this stuff built in. How would you replicate data and images across multiple locations? > -----Original Message----- > From: Adam Churvis [mailto:[EMAIL PROTECTED] > Sent: Monday, February 19, 2007 1:30 PM > To: CF-Community > Subject: Re: Storing images in DB. > > Nick, > > Have you ever tried this *under load* with either a large number of > images on a single web page, a single large image, or a combination of > these? It all seems about the same on the work bench, but it's a whole > different story under load, which is all that really matters. This is > why Microsoft itself employs sophisticated caching schemes to eliminate > the need to touch the database for binaries any more than it absolutely > has to. > > Also, look at every single step of what *actually* happens when you > retrieve binary data from the database, serve it, and convert it. > You're being a bit too simplistic when you mention the pointer stored > in the table, as if that somehow makes it like a direct file retrieval > from disk. There's a lot of work that's done to make this happen, and > it does make a difference that you'll notice under a realistic load. > > Respectfully, > > Adam Phillip Churvis > Certified Advanced ColdFusion MX 7 Developer > BlueDragon Alliance Founding Committee > > > > Get advanced intensive Master-level training in > C# & ASP.NET 2.0 for ColdFusion Developers at > ProductivityEnhancement.com > > ----- Original Message ----- > From: Nick McClure > To: CF-Community > Sent: Monday, February 19, 2007 10:44 AM > Subject: RE: Storing images in DB. > > > We aren't talking about static page images, those types of images > should be > on the web server. He is looking for a way to ensure that the data > and the > images aren't kept separate from each other. > > In an environment such as this, keeping the images in the database is > a > great idea. The data is stored in a fairly similar way, binary data > such as > this isn't stored in the tables, the table only holds a pointer to > the > actual data. The performance change from accessing the images via a > networked file server vs a database isn't going to be major for a > small > percentage of images. > > > > > -----Original Message----- > > From: Adam Churvis [mailto:[EMAIL PROTECTED] > > Sent: Monday, February 19, 2007 10:25 AM > > To: CF-Community > > Subject: Re: Storing images in DB. > > > > Listen to Rick. And picture in your minds the two very different > pipes > > needed to retrieve, process (or not) and serve, and the mechanisms > > through which each must pass, and how the system's resources react > to > > each. Think about how database-persisted binary data is physically > > stored, retrieved, delivered, and converted. > > > > Even systems like SharePoint rely on a combination of disk caching > and > > page output caching after the first retrieval of a page's > constituent > > parts from the database. Database storage is for management > > convenience only; a sophisticated scheme is employed to get those > > assets out on disk as regular files and then serve them from there. > > > > Respectfully, > > > > Adam Phillip Churvis > > Certified Advanced ColdFusion MX 7 Developer > > BlueDragon Alliance Founding Committee > > > > > > > > Get advanced intensive Master-level training in > > C# & ASP.NET 2.0 for ColdFusion Developers at > > ProductivityEnhancement.com > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:228355 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
