>Stupid question, but - what stress testing did you do on your app >before you deployed it? > >Mark > >On Jan 24, 2008 4:53 AM, Vesko Kehayov <[EMAIL PROTECTED]> wrote: >>
Mark, When we first decided to implement cfqueryparam, we stress tested the customer facing portion (which gets 95% or more of all the traffic) with no noticeable increase. Based on these results and the fact that all the research regarding queryparam focuses on the performance gains by using it, we were comfortable moving forward with this change. We spent most of our research time focusing on data related issues with queryparam. We first deployed queryparam changes in the content management area of our application which gets very little traffic and the memory increased to what it is now. At that time it wasn't clear what the reason for the increase was because we also enabled global script protect and other changes in an overall effort to secure our application. All other changes have been reviewed and removed as possible reasons for the increase. This leads me to think that the fact that we have 1000 datasources regardless of traffic and 1000 pooled statements per datasource, could mean trouble and traffic may not be a factor. We have decided to temporarily lower the ColdFusion default from 1000 max pooled statements and monitor the memory as well as the other important server metrics to make sure that this change does not create new problems. I'll post our finding to the group, so that we all can benefit. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297233 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
