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
