We are managing huge SYBASE IQ databases and looking for ways to increase
performance. Your comment on stored procedures (5x quicker) really caught my
attention since our queries are also huge. I check allaire's knowledge base and
my current CF books (incl.Forta's Advanced Cold Fusion 4.0) and can find
nothing extensive. Is this all there is or are there other sources of
information
re: STORED PROCEDURES. Any help with information or pointing me towards
information would be very helpful.
Thanks,
Carol
Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]
____________________Reply Separator____________________
Subject: Re: Performance question - CFINCLUDE versus writing a custom
Author: [EMAIL PROTECTED]
Date: 1/30/01 5:24 PM
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
