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
