A site? A single site? In my experience, performance issues come down to a few things: Poor (or no) scoping choices, poor SQL (both query execution plans and general server health), and an improperly tuned JVM. Most of the time, for me, it appears to be the DB. Either the queries are terribly written, there aren't any indexes on tables, or both (and more).
Have your tried FusionReactor yet? FR can be a great resource for finding and resolving bottlenecks and poorly written code, and I think there's a 10 trial download. Hiring guys like Mike Brunt and Charlie Arehart are well worth the money too. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer ____________ http://blog.cutterscrossing.com Co-Author "Learning Ext JS 3.2" Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book "The best way to predict the future is to help create it" On 6/28/2011 12:33 PM, Richard Steele wrote: > Yes, for sure.... in an ideal world. However even though we have CF > Enterprise, we can only have two instances for this particular site due to > hardware and budget constraints. When traffic increases due to some link to > the site going viral (which is unusual), it would be impossible for the > server to keep up with the requests even if the requests were all processed > under a second. Then requests would build up in the queue awaiting > processing. People then get impatient and start clicking the link over and > over, further exacerbating the problem. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
