Yep, there's quite a few queries without cfqueryparam - but again, this is behavior that has popped up of late - this is code that's been around for years that hasn't had this sort of issue. So I don't know that this is a problem.
I'm unsure as to recovery model - we have a hosting guy who maintains the DB box. On 5/16/11 9:50 AM, Charlie Stell wrote: > Do you have many queries (especially queries ran very often) that do not use > cfqueryparam? Those symptoms remind me of system I worked in once where most > of the queries were not using queryparam or any other form of binding - and > as a result sql's query cache was filling up too often... though I'm sure > many other things could be the culprit : ) > > What recovery model is your db using? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
