You might want to consider writing out the dynamic pages as static HTML files.
If the contents of the pages tend not to change on a daily basis than you may want to rethink storing the contents in a database. If the DB storage if for purposes of content management, than instead of generating the pages at each request, or even caching the queries as Dave suggested, you might just want to sump the completed webpages to static HTML files. This saves on network traffic (to/from the DB), load on the DB, load on the application server, and memory. If, however, the contents *DO* change on a regular basis, than caching the queries may not be a valid option either. In that case, you may want to rethink your approach. Out of curiosity, why are the page contents being stored in the database? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Aunger, Mitch [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 12, 2002 6:16 PM > To: CF-Talk > Subject: CF dynamic content server load (was: Large Corporations that > use ColdFusion) > > > I've got a similar question (to the original subject) that has reared (no > pun related to Victoria Secret site) its ugly head again here at my office > (question forms slowly and is really at the bottom). > > I've been asked to improve a section of our external website relating to > Press Releases. A similar site that I've done creates web pages > that appear > to the end user as if they were basically static - tho the > content is almost > totally derived from data stored in a database. > > Now, I've proposed doing the Press Releases in a similar way - all content > and much of the formatting being stored in an oracle database. However, my > web 'gurus' are saying that we can't possibly put dynamic content on the > external site because each page could have 50,000+ hits a day and > that would > overload our servers. I'm guessing that their 'fear' is based on > a bad past > history with ColdFusion. (Gee.. I hope none of them are on this > list and are > easily offended <g>) > > So, when this thread came out, I looked at the VictoriaSecret > site figuring > it probably gets more than 50,000 hits per day... right? It seems > to be VERY > reponsive! ColdFusion doesn't look so bad on their site ;) > > > QUESTIONs: can anyone provide me with realistic comments/examples of HIGH > VOLUME DYNAMIC page content or ideas on how I can assure my managment that > ColdFusion dynamic content will not kill the servers? Are there > recommended > tools for analyzing loads and network problems (I once looked at Mercury's > TOPAZ)? > > How do I fight this perception that CF pages must be slow server hogs? > > > I'll be glad to chat off the list if you want > > (Note: Should this topic be on the 'community' list?) > > Thanks > Mitch > Lowly web developer trying to fight the evil webmasters <g> > > > > -----Original Message----- > From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 11, 2002 8:08 AM > To: CF-Talk > Subject: RE: Large Corporations that use ColdFusion > > > www.VictoriasSecret.com > > ______________________________________________________________________ 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
