I (personally) find using stored procedures instead of simple queries to be a nuisance for anything but large, cross-platform projects. Instead of replacing simple queries with stored procedures, you can just use <cfqueryparam> to get the same performance benefit (query plan reuse) in SQL Server or Oracle.
--Daryl Banttari Macromedia ----- Original Message ----- From: "Adaryl Wakefield" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 12:58 PM Subject: Re: [KCFusion] deletes on database? > Hey why is it every time I post something it generates an avalanche of > activity. :-) Its like you guys forget this thing exist. > So (and anybody can field this one) I was studying how to write stored > procedures in SQL Server last night I was like..gee. thats a lot of freaking > work. So what would you say was the most appropriate time to use stored > procedures vs. just putting it on the page. > A. > P.S. As a matter of fact Misty, no, I don't have a job....I'm a consultant! > > ----- Original Message ----- > From: "Misty Woodward" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, September 12, 2002 10:59 AM > Subject: RE: [KCFusion] deletes on database? > > > > In one of the projects I am working on now, they use Oracle stored > functions only for database calls. When I first started doing it, I hated > it. Honestly, I still hate it. From a development standpoint, as far as time > goes, i would say it takes longer than just writing it directly into CF. > When Im coding in CF I just write out my CF query and move on. When writing > Stored Functions your 8 line query turns into a huge function where you have > to declare varaibles, check for variabls, create the function, create your > IN Variables, write in your return values, etc. The part that Stored > Functions shine in, is with code re-use. The function I wrote is to be used > across 3 systems. Which means, I only have to change it in one place and I > can manage all 3 sites with it. > > > > Misty > > > > ---------- Original Message ---------------------------------- > > From: "Glenn Crocker" <[EMAIL PROTECTED]> > > Reply-To: [EMAIL PROTECTED] > > Date: Thu, 12 Sep 2002 10:50:12 -0500 > > > > >MessageI generally don't do any JOINs in my CF code, instead using > > >queries/views to accomplish them. (Sometimes, when a parameter needs to > be > > >way inside a JOIN, I'll put one in CF.) I haven't done the full-on > stored > > >procedure architecture, but most of my projects are just one or two > > >developers, so it's not a big team thing with lots of turnover. > > > > > >-glenn > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > > >Behalf Of Ryan Hartwich > > > Sent: Wednesday, September 11, 2002 10:28 PM > > > To: [EMAIL PROTECTED] > > > Subject: RE: [KCFusion] deletes on database? > > > > > > > > > Adaryl, > > > > > > Somewhere I interviewed or spoke with someone about this topic. It was > my > > >understanding that the individual coders being employed were generally > not > > >allowed to do any form of insert/update/delete into the database through > > >their code. They were however permitted to write Select statements to > > >tables and/or views. The coders were given a set of API calls utilizing > > >XML services internally to do the direct DB manipulation. The idea was > to > > >force data integrity and consistency by only allowing data to be modified > > >through approved prebuilt modules. > > > > > > A permutation of this would be to not permit inline DB calls in your CF > > >code and to call all DB statements via stored procedures. I have heard > this > > >speeds up development, improves reusability, and quality. I'm a bit > > >skeptical of this however. I have spent a few years writing code as the > > >primary developer and write my SQL code directly inside of my CF pages. > At > > >least for small development teams with ad-hoc design standards that > change > > >frequently I think the extra overhead of standardizing and separating the > > >layers adds significant complexity. However, I would love to hear from > > >those who have used this method in large, formal design groups. It may > be > > >the way to go. > > > > > > Ryan > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > On > > >Behalf Of Adaryl Wakefield > > > Sent: Wednesday, September 11, 2002 10:10 PM > > > To: [EMAIL PROTECTED] > > > Subject: [KCFusion] deletes on database? > > > > > > > > > I once saw a job announcement that said something to the effect. > "..no > > >deletes on the database will be allowed. All deletes are done via XML..." > At > > >the time I just raised my eyebrow and went on but now I'm kinda curious > if > > >anybody can shed some light on what exactly they meant. I only have an > > >academic understanding of XML and a small one at that. > > > A. > > > > > > > > > > > > ______________________________________________________________________ > > The KCFusion.org list and website is hosted by Humankind Systems, Inc. > > List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org > > Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] > > To Subscribe.................... mailto:[EMAIL PROTECTED] > > To Unsubscribe................ mailto:[EMAIL PROTECTED] > > > > > > ______________________________________________________________________ > The KCFusion.org list and website is hosted by Humankind Systems, Inc. > List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org > Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] > To Subscribe.................... mailto:[EMAIL PROTECTED] > To Unsubscribe................ mailto:[EMAIL PROTECTED] > > ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]