I guess I'm not stunned by this, but I can't really explain it. I mean, using cfqueryparam forces CF to use bind variables to send to the query... and it does some level of data validation probably though I'm not sure the CF side of things handles any of that (though I suspect the maxlength attribute is handled by CF at the very least).
So your memory usage goes up. But what about the performance? If individual queries are run many many many times, the use of cfqueryparam in a high traffic system should provide significant performance improvements on top of the obvious security benefits Memory is relatively inexpensive too, really - unless the extra memory forces you to buy a significantly more expensive server or operating system. Rick On 1/22/08, Vesko Kehayov <[EMAIL PROTECTED]> wrote: > We have a large content management application used by retailers to manage > their website content and website storefront. The application uses ColdFusion > 7.02, MSSQL Server 2000 and IIS. We have a load balanced environment with 5 > webservers. The application has over 10,000 cfquery tags and until recently > we did not use cfqueryparam. We upgraded the application to use cfqueryparam > in all queries and noticed a significant increase in the JRUN Working Set > usage on all webservers. Prior to the upgrade the JRUN working set was flat > at roughly 550 mb and after the change the JRUN working set climbed over > 800mb. > > Has anyone else ever experienced this or have additional knowledge as to why > the webserver memory usage has increased so significantly. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:297096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
