Converting intensive queries to stored procedures is the single most
performance tweak you can do for a CF site. I've seen SP's perform up to 5
times as fast as a regular <cfquery>
jon
----- Original Message -----
From: "Kevin Gilchrist" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 4:00 PM
Subject: Re: Performance question - CFINCLUDE versus writing a custom CF
> Unfortunately stored procedures aren't an option.
> What would that gain me anyway? Is it just more efficient for the queries
> to be executed by the DB (Oracle in this case)?
>
> Going by Philip's answer, I guess doing CFINCLUDE'a are the way to go.
>
> "Steve Bernard" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Are stored procedures not an option?
> >
> > Steve
> >
> > -----Original Message-----
> > From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 30, 2001 12:07 PM
> > To: CF-Talk
> > Subject: Performance question - CFINCLUDE versus writing a custom CF
> >
> >
> > Hi all,
> >
> > I'm writing a web app that acts as a dashboard for an MSP, i.e. a GUI
that
> > shows the status of all sorts of applications, network and host
devices.
> I
> > need to write quite a few select queries for each device/host/app type,
so
> > will end up with ~150 different queries.
> >
> > What I'm wondering about is if anyone has any thoughts on whether it's
> > better to access these queries from the GUI templates using
> >
> > - a series of conditional CFINCLUDE's that would include a smallish
query
> > template.
> >
> > - or write a custom CF tag with all the queries inside and pass three
> > parameters that would give me a unique query name. A three deep CFWITCH
> > statement could home in on the relevant query.
> >
> > Is it correct to assume that it's a bigger hit on CF to call on a
> relatively
> > large templates even though it's doesn't have to process much of it (cf_
> > tag), as opposed to including whole but small templates?
> > I guess it may be better organizationally to implement the queries as a
> > bunch of small files to include?
> >
> > It seems like a case of six in one, half a dozen in the other but I'll
> never
> > know if I don't ask...
> >
> > Thanks,
> > Kevin
> >
> > P.S. I intend to convert it all to fusebox for version 2.
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
