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 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:228336 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
