Hi, the majority of our sites user a fairly standard database call (most often to MS Sql servers) for their dynamic content (see below).
While I have never noticed any performance issues I have been told that this would run better using stored procedures. Can anyone outline the benefits / costs (one cost being some recoding) of using stored procedures and if necessary how I would adapt the query? Thanks! James <cfquery name="qPageBody" datasource="#REQUEST.datasource#" username="#REQUEST.username#" password="#REQUEST.password#" > SELECT pageName,pageBody,pageHeader,pageJoin,relatedPages FROM #REQUEST.navTable# WHERE 1=1 AND id=<cfqueryparam value=#defaultPage# cfsqltype="cf_sql_integer"> </cfquery> --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
