If you feel you need to grab the generated content into a variable (for
whatever reason) and you are using cf 5, there is cfsavecontent, if you are
using something prior to 5 then you could use the cf_bodycontent custom tag
(possibly available in dev exchange, for sure available at fusebox.org).
Basically you would wrap the code that generates output with one of the
tags, and where you want to display it (or in your case put it in the
database) you would just use the variable.
-----Original Message-----
From: Patrick Harkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 8:41 AM
To: CF-Talk
Subject: RE: I'm resending - help
Michael:
I read your question and it is not entirely clear but I get the general
drift. What you are asking suggests that the architecture of what you are
doing is unweildy.
Not to be annoying, but you are asking ColdFusion to do too much - believe
me I know this from experience. ColdFusion should only be used as the glue
to integrate your output. It is not designed to be a workhorse.
What database are you using? You can probably do a lot of the work on the
database side, if you are using a true database server, using triggers and
stored procedures. It sounds to me like you may well be in need of a whole
separate OLAP database. That is where I would suggest that you direct your
thoughts - it will save you a whole lot of grief, and your server will
continue to be your friend.
Patrick Harkins
-----Original Message-----
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: September 20, 2001 6:46 AM
To: CF-Talk
Subject: I'm resending - help
Resending this, please take a look (haven't got response).
I have a complexed CFM template that output a result page after a long
process.The process includes: connecting to 3-4 diffrent datasources, string
manipulation, math calculations, links, includes, everything...
I though about the following way to cache: Every cfoutput (and other html/js
code) is
store incremently in a cf variable. (upon succesful completion of every
phase).
In the end, I output the result to the user and store that variable in a SQL
table with a UID. Then, the second time a user calls the CFM, I first check
if the output
content is already in SQL, and output it. If the content is not there, or
expired, I simply parse the
CFM from the start.
Any comments on my way to do this?
What is better in this way, store the output content in SQL or a text file
(and then <cfinclude> it)?
Michael.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
