Well the SP used in the example is poor - which is no doubt why it had bad performance.
-----Original Message----- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: 30 October 2005 22:31 To: CF-Talk Subject: RE: Philosophy Q: SP's or CFQUERY? You mention SP's will give greater performance. I think that may be a myth these days. Google around and you will find all sorts of debates on it. I was shocked myself after spending a good bit of day taking some queries from a CF page and dumping them into a shiny new stored proc and things didn't improve and actually seemed to slow down some. Here is one link http://weblogs.asp.net/fbouma/archive/2003/05/14/7008.aspx but there are many. -----Original Message----- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Saturday, October 29, 2005 1:16 PM To: CF-Talk Subject: Philosophy Q: SP's or CFQUERY? I'm going back and tweaking a web app that I'm building and have learned a few stored procedure tricks (my SP skills were pretty basic before I started to play around). As a result, I'm replacing a number of CF queries (using cfqueryparam) with SQL Server stored procedures. Now, these are pretty much limited to the customer-facing (non-admin) pages, though I'm using SP's in the admin where I already have them written to return the rest sets that I need. Realizing that SP's will give greater performance, the question is this: Is it OK to write your most frequently run queries as SP's and leave the rest of the site as straight SQL queries? Or should I just make the entire site SP's? What I've been doing during development is writing straight SQL until I get what I need, then I rewrite as a SP. I've replaced a dozen or so queries that are all on the customer-facing end of things, but there are well over 100 queries still written as SQL on the admin side, and it would take a bit of effort to convert (or merge into existing SP's) those queries. Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222703 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
