Well I know some that use stored procedures for everything. For me, I try to use them only when things get complex. For instance, Im writing an application that goes into the database checks who a shipper is based on a mailstop, based on that it does another query, takes the result of that query and goes into another database pulls out the next tracking number then calls another Oracle function within it. So you can see the more jumping around i have do, the more it makes sense to do it on the Oracle box instead.
The other reason regardless of what makes sense, is some companies force you to put everything into stored procedures or functions no matter what. There are a lot of companies now moving to not letting CF programmers write SQL statements and instead having database guys do it because they are more efficient in writing SQL (ya I dont buy that either) but it is thought to be better. Make the database better by letting the people who specialize in it write the queries. This makes sense I suppose but its a big increaser of development time. Ive literally sat here twiddling my thumbs for hours waiting on my DB guy to come back and load my oracle function for me to test it. it sucks. But thats company processes at work! :) Misty ---------- Original Message ---------------------------------- From: "Adaryl Wakefield" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 12:58:32 -0500 >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]
