My first inclination is to ask if the content is going to be changing every minute. If not you can cache the queries and set them to expire maybe once a day or twice a day. If you don't want to keep them up in memory, you could write the data to a file(s) once or twice a day and do an include. All of this is just off the top of my head, but that would keep you from having to hit the DB for every single person that hits the Press Releases section. Maybe in the admin you could have a check box that would signal that this page needs to be posted immediately and it would rewrite those pages or clear that cached query. I hope that helps. Those are a couple of solutions that avoid the whole how good is CF argument, maybe.
Dave David Livingston Network Admin 214-871-9117 [EMAIL PROTECTED] -----Original Message----- From: Aunger, Mitch [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 5: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
