> >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.
Group, I set the max pooled statements to 0 for all datasources. This change did not resolve the memory issue introduced by cfqueryparam. I welcome other possible suggestions on how to address this issue. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297613 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4