The whole idea of stored proceedures etc. is to move your programming logic
and business rules on to the RDBMS which has been optimized to handle them.
Also  only one connection is required between your server and the data
source.

I agree with Mike that the it doesn't really matter what front you use, (I
prefer ASP because I can mix and match with XML and other data sources). The
actual execution of your code whether it be ASP or CF is a minimal part of
the overall process. The important thing if you are worried about
performance is to optimize your DB, and to move as much logic as you can on
to your RDBMS.

Most performance hits come from poor DB design, and making multiple
connections to your  RDBMS rather than the front end you are using.

I mean if we were really worried about the speed of code execution perhaps
we should be writing native drivers in C++ rather than using a fron
end.!!:>)

Frank

----- Original Message -----
From: "Mike Kear" <choicemag(at)hotmail.com>
To: <bckman(at)ix.netcom.com>; <allred(at)allrednet.com>; <hwg-techniques(at)hwg.org>
Sent: Friday, August 10, 2001 4:57 PM
Subject: Re: Coldfusion vs ...


>
>
> Sure Frank.  One line in fact.
> For example:
> <.cfquery name="Storedprocedure" datasource="DSN">exec
> storedprocedurename<./cfquery>
>
> And you can send SQL commands to the database directly.   For example:
>
> <.cfquery name="getitems" datasource="DSN">Select * From
> tablename<./cfquery>
>
> (Of course you can put it on more lines if it improves readibility.)
>
> Cheers,
> Mike Kear
> Windsor, NSW, Australia
> AFP Webworks.
>
>
> >From: "Frank Boumphrey" <bckman(at)ix.netcom.com>
> >To: "John Allred" <allred(at)allrednet.com>, <hwg-techniques(at)hwg.org>
> >Subject: Re: Coldfusion vs ...
> >Date: Fri, 10 Aug 2001 16:12:44 -0400
> >
> ><john>
> >5) Tell me if I'm wrong about ASP on this point, but I suggest that CF
> >gives you more flexibility in the reuse of SQL queries. Using CF, you
> >can create SQL that derives its values from the currently available
> >variables. You can even include IN, WHERE or other SQL clauses, or not,
> >depending on the values passed in.
> ></john>
> >
> >Views,stored proceedures and triggers are all functions of your database
> >rather than the front end you are usiing to access it. They are set with
> >SQL
> >calls.
> >
> >In ASP you can do this with a few lines of code, provided you have the
> >correct permissions. (Again a function of the RDBMS you are using). I
> >assume
> >you can do the same thing with CF.
> >
> >Frank
> >----- Original Message -----
> >From: "John Allred" <allred(at)allrednet.com>
> >To: <hwg-techniques(at)hwg.org>
> >Sent: Friday, August 10, 2001 2:00 PM
> >Subject: Re: Coldfusion vs ...
> >
> >
> > > Mike,
> > >
> > > Cold Fusion has received a ton of criticism from folks who like open
> > > source, or "free" web application development software. Most of it is
> > > unfounded and is passed along as truth, when it's not.
> > >
> > > Just a few points to dispel any false impressions that some might
have,
> > > if they are exploring software options:
> > >
> > > 1) Cold Fusion is not a point and click application. If you don't
> > > understand the concepts behind a web application and how to construct
> > > one, its ease-of-use features will do you absolutely no good.
> > >
> > > 2) If you do understand the mechanics behind a data driven web site
and
> > > you have some grounding in programming concepts, Cold Fusion will make
> > > your life much easier, because it facilitates development by
experienced
> > > programmers.
> > >
> > > 3) Many of the functions that require COM objects with ASP are built
> > > into Cold Fusion Server, so they're very simple to access and don't
> > > require a VB or C++ programmer on the payroll. But, if COM objects are
> > > the best solution, Cold Fusion presents no obstacles to using them.
> > >
> > > 4) Your comparison between Access Data Pages and ASP applies, with
equal
> > > weight, between ASP and Cold Fusion.
> > >
> > > You said:
> > > > Hundreds of lines of extra code. I could perform the same functions
> > > > in 50 lines [using ASP] that an Access Data Page does in a couple
> >hundred.
> > >
> > > If this is an important factor for you, then you'd do well to give
Cold
> > > Fusion another look. Using Cold Fusion, a developer could condense the
> > > same functionality by at least a factor of five over what he might
write
> > > in ASP. In many cases, by much more.
> > >
> > > 5) Tell me if I'm wrong about ASP on this point, but I suggest that CF
> > > gives you more flexibility in the reuse of SQL queries. Using CF, you
> > > can create SQL that derives its values from the currently available
> > > variables. You can even include IN, WHERE or other SQL clauses, or
not,
> > > depending on the values passed in.
> > >
> > > Regards,
> > > John Allred
> > >
> > >
> > > Mike Carlson wrote:
> > > >
> > > > I have been told on several occasions by CF and ASP developers that
a
> > > > good analogy would be:
> > > >
> > > > "Cold Fusion is the "velcro" of web development. Very fast to
develop,
> > > > very easy to use, but if you are in for the long haul and are going
to
> > > > need it to scale infinitely, CF is not the way to go. Departmental
> > > > websites, small internet websites (under 10,000 hits a day) are fine
> >in
> > > > CF. But large scale e-commerce, high traffic sites, do not do well
in
> > > > CF."
> > > >
> > > > Everytime I get to a site that is run on CF, it is pretty slow.
> > > >
> > > > I compare it to Access Data Pages and ASP. They both perform the
same
> > > > functions (web interface to db) but the Access versions are always
> > > > slower and if you look at the code behind it, you can see why, there
> >is
> > > > a lot of stuff going on that is not needed. Hundreds of lines of
extra
> > > > code. I could perform the same functions in 50 lines that an Access
> >Data
> > > > Page does in a couple hundred.
> > > >
> > > > I would not use any "write and application using point and click" to
> > > > develop an application that was business related.
> > > >
> > > > ************************
> > > > Mike Carlson
> > > > http://www.domitianx.com
> > > > domitianx(at)domitianx.com
> > > > ************************
> > > >
> > > > -----Original Message-----
> > > > From: owner-hwg-techniques(at)hwg.org
> >[mailto:owner-hwg-techniques(at)hwg.org]
> > > > On Behalf Of Jeff Rankin
> > > > Sent: Friday, August 10, 2001 7:01 AM
> > > > To: Klaas De Waele; hwg-techniques(at)hwg.org
> > > > Subject: RE: Coldfusion vs ...
> > > >
> > > > Cold Fusion is a server-side development environment consisting of a
> > > > server component that integrates with a web server, a markup
language
> > > > that integrates with HTML (and looks alot like it), and a fairly
nice
> > > > IDE (it's a lot like Homesite). The server component is available
for
> > > > Windows Server platforms, Solaris, HP-UX, and Linux.
> > > >
> > > > Cold Fusion is a very well-integrated environment. The markup
language
> > > > is fairly easy to learn but very powerful. It works well with SQL
> > > > Server, Oracle, and many other database platforms. Because of these
> > > > reasons, our developers like it much more than Microsoft's
alternative
> > > > (ASP).
> > > >
> > > > I'm not sure about the cost, as I don't have to handle the
> >acquisition.
> > > >
> > > > =================================
> > > > Jeff Rankin     jrankin(at)oneil.com
> > > > Lead Publications Programmer
> > > > O'Neil & Associates, Inc.
> > > > http://www.oneil.com/
> > > > 937.461.1602 x 3504
> > > > =================================
> > > >
> > > > > -----Original Message-----
> > > > > From: owner-hwg-techniques(at)hwg.org
> > > > > [mailto:owner-hwg-techniques(at)hwg.org]On Behalf Of Klaas De Waele
> > > > > Sent: Friday, August 10, 2001 5:34 AM
> > > > > To: 'hwg-techniques(at)hwg.org'
> > > > > Subject: Coldfusion vs ...
> > > > >
> > > > >
> > > > > A quick question to all of you.
> > > > >
> > > > > We've just lost a job with a database management tool website to a
> > > > > competitor.  We thought we had a nice and cheap solution (as in
> > > > > Chrysler Stratus Cabrio cheap) but this other guy we don't know
> > > > > offered it for a lower price using ColdFusion.
> > > > >
> > > > > What I'm looking for is someone who can explain me the benefits of
> > > > > ColdFusion over ASP or the likes.  I would say if you need a
> > > > > ColdFusion server and expensive creation tools you'd go past the
> >proce
> > > >
> > > > > of ASP, since I'm using just Notepad ad Editpad to create my apps.
> > > > >
> > > > > So...
> > > > > - what's cold fusion?
> > > > > - how is working with it
> > > > > - prices for development in relation to ASP (factors).
> > > > >
> > > > >
> > > > > - Kayjey -
> > >
> > > --
> > > "Once in a while it really hits people that they don't have to
> > > experience
> > > the world in the way they have been told to." - Alan Keightley
> >
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>

• Web Designer Courses
• Off the Shelf Training Courses

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA