An increase of the number of queries being executed via cfquery where queryparam isn't being used - regardless of it being from a user request or a scheduled process...
On Mon, May 16, 2011 at 12:13 PM, Scott Weikert <[email protected]> wrote: > > No, no recent updates (that I'm aware of), no increase in traffic. > > When you say "request increase" are you talking about behind-the-scenes > DB requests? Or an increase in usage by people with a corresponding > increase in DB traffic? > > On 5/16/11 10:06 AM, Charlie Stell wrote: > > Have you recently upgraded versions of MS-SQL? And/or recently had a > > significant increase in requests? > > > > In the system I was referring to, it had been running for 3 years without > > this being an issue - then we upgraded to SQL 2005 and had a request > > increase of about 25% - at this point we started having DB hangs about > every > > other day. I don't know if it was the load increase or a change in > execution > > plan handling by SQL... but the db hangs stopped as soon as we > incorporated > > cfqueryparam. > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
