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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:228354 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
