What constitutes underload? I see this (or other abstract, vague terms) constantly in the community and I think vague words like this can cause confusion and may lead someone down a path without true understanding. Your idea of under load may be *very* different than another's. In our environment (Enterprise Intranet Systems for our 2500+ stores) under load, or heavy load, may be 100 requests per second. In the ecommerce company (<$5 mill/year) 20 requests per second was under load. So what exactly is the definition of under load?
Adam Haskell On 2/19/07, Adam Churvis <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:228393 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
