An alternative arguement... I have the same app distributed in multiple intranet applications that I do not have direct access to. Having to coordinate both page changes and db changes can be a logistical nightmare.
If all my code is in the page, then an upgrade is simpler. Also, I find it more readable if it's all in the one spot. Flame away if you must - please keep the heat down! Phil. ----- Original Message ----- From: "Taco Fleur" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Friday, May 28, 2004 2:10 PM Subject: [cfaussie] RE: Stored Procedures - worth changing to? > > 1. business logic located in the database > 2. stored procedures execute faster as an execution plan is saved > 3. more secure > 4. easier to manage > 5. return lots of result sets with only one call to the sp > 6. easier to re-use > 7. i could come up with more but I hope this will convince you > > Converting your existing queries to Stored Procedures isnt to difficult, but whether its worth it?? I reckon from now on you should use Stored Procedures, that will give you more benefit, unless you are also allowed to recode the SQL statements? > > Taco > > -----Original Message----- > From: James Cowperthwaite [mailto:[EMAIL PROTECTED] > Sent: Friday, 28 May 2004 2:09 PM > To: CFAussie Mailing List > Subject: [cfaussie] Stored Procedures - worth changing to? > > > 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 > > Register now for the 3rd National Conference on Tourism Futures, being held in Townsville, North Queensland 4-6 August - www.tq.com.au/tfconf > > --- > 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 > --- 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
